Aligning Text in Cells

When you enter data into an Excel worksheet, that data is aligned automatically. Text is aligned on the left, and numbers are aligned on the right. Both text and numbers are initially set at the bottom of the cells. However, you can change both the vertical and the horizontal alignment of data in your cells.

Follow these steps to change the alignment:

  1. Select the cell or range you want to align. If you want to center a title or other text over a range of cells, select the entire range of blank cells in which you want the text centered, including the cell that contains the text you want to center.

  2. Pull down the Formatmenu and select Cells, or press Ctrl+1. The Format Cells dialog box appears.

  3. Click the Alignment tab. The alignment ...

Get Ten Minute Guide to Excel 97 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.