How to align text within a cell

1. First, select the cell or range you want to format

2. Click the Home tab

In the Alignment Group: To align text horizontally

3. Click the Align text left command to align text in the selected cell or range to the left hand side of each cell.

how to align text within a cell

4. Click the Align text right command to align text in the selected cell or range to the right hand side of each cell.

how to align text within a cell 2

5. Click the Center text command to align text in the selected cell or range in the center of each cell.

how to align text within a cell 3

 

In the Alignment Group: To align text vertically

6. Click the Top Align text command to align text in the selected cell or range to the top of each cell.

how to align text within a cell 4

7. Click the Middle Align text command to align text in the selected cell or range to the middle of each cell.

how to align text within a cell 5

8. Click the Bottom Align text command to align text in the selected cell or range at the bottom of each cell.

how to align text in a cell 6

Excel performs to commands for you.

Lesson 32: How to center text across multiple Columns

 

 

Submit a Comment

Your email address will not be published. Required fields are marked *