Aligning Text in a Cell

   Overview   

You can align text in a cell vertically (at the top, middle, or bottom of the cell) and/or horizontally (to the left, center, or right of the cell).

   Instructions   

  1. Step 1: Click the column header that you wish to align.
  2. Step 2: On the Home tab, click the appropriate alignment option to display your text.
  3. Step 3: If the text is too long, click the Wrap Text icon located to the right of the alignment options.

In this article, you will learn the steps to align text in a cell within an Excel worksheet.

1. Step 1

step image

The Excel worksheet is displayed. From the worksheet, select the appropriate cell(s) that contain the text you want to align.

Example shown here: Click column header J to select all cells in that column.

2. Step 2

step image

On the Home tab, click the appropriate alignment option to display your text.

Note: You can align cells vertically (top of cell, middle of cell, and bottom of cell) or horizontally (left, center, and right).

Example shown here: Click the Center option to center the text in the cell.

3. Step 3

step image

The text in the selected cell is now re-aligned.

If you have a long line of text, part of the text might not be visible. To fix this without changing the column width, click the Wrap Text button.   

Print Article

Attachments (0)

No attachments found.