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.

Difficulty: Easy

Instructions

Things You'll Need:

• Excel Book
• Microsoft Excel

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.

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.