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

Details

Article ID: 148783
Created
Sat 9/24/22 10:54 PM
Modified
Fri 1/5/24 5:04 PM