How to Align Text in Excel Cells
Use the Alignment option in Excel to specify the horizontal and vertical alignment of your row and column labels. These steps work with Microsoft Excel 97.
Other People Are Reading
Instructions
-
-
1
Start Microsoft Excel and open the file you want to change.
-
2
Select the cells in which you want to align the text.
-
-
3
Open the Format menu and select Cells.
-
4
In the Format Cells dialog box, select the Alignment tab.
-
5
In the Text Alignment pane, click the horizontal text box.
-
6
Select the horizontal alignment type such as left, right, center.
-
7
Click the vertical text box.
-
8
Select the vertical alignment type, such as top or bottom.
-
9
Select OK to accept the changes.
-
1
Tips & Warnings
You can use the toolbar selections to align your text horizontally. Select left, right, or justified icons from the toolbar.
To undo your changes, open the Edit menu and select Undo Format.
Use the Format Cells dialog box to add other formats to your cells.
More Like This
Comments
-
you select the arrow in the top left corner where the numbered and lettered cells are that will select the entire spread sheet (or ctrl + A) then select your format and bobs your uncle.
-
how can you make the alignment you need as standard for all the cells in the excel, rather than adjusting the format for every cell in the worksheet?
