Text Alignment in Excel

Text Alignment in Excel

Text alignment is not as useful in Excel as it is in Word. The most useful alignment in Excel is centering text.

There are four different alignment option: left align, right align, center, justified.

I think we will concentrate on centering and a special button called merge and center. You can still use the other alignment options but they aren't that useful for text.

I will show you cell alignment in a later lesson. Now that is something.

Use center and/or center and merge for your headers or sub-titles or footers or any other text you see fit.

How to Center Text in Excel:
Image Tutorial

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Type in text.
3. Click on the cell with the text you would like to align.
4. Click on the center symbol on the formatting toolbar.

Or (instead of step 4)
5. Click Format on the menu bar.
6. Click Cells.
7. Select the "Alignment" tab.
8. Click on the arrow for horizontal alignment.
9. Click on "Center".
10. Click OK.

How to Center and Merge Text in Excel:
Image Tutorial

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Type in text.
3. Click on the cells with the text you would like to center and merge. We need to select multiple cells to merge. We will select A1, B1, and C1.
4. Click on the center and merge symbol on the formatting toolbar.

How to Left Align Text in Excel:
Image Tutorial

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Type in text.
3. Click the cell with the text you would like to left align.
4. Click on the left align symbol on the formatting toolbar.

Or (instead of step 4)
5. Click Format on the menu bar.
6. Click Cells.
7. Select the "Alignment" tab.
8. Click on the arrow for horizontal alignment.
9. Click on "General". (this is the default setting)
10. Click OK.

How to Right Align Text in Excel:
Image Tutorial

1. Open Microsoft Excel.(How do I open microsoft excel?)
2. Type in text.
3. Highlight the text you would like to align.
4. Click on the right align symbol on the formatting toolbar.

Or (instead of step 4)
5. Click Format on the menu bar.
6. Click Cells.
7. Select the "Alignment" tab.
8. Click on the arrow for horizontal alignment.
9. Click on "Right".
10. Click OK.

You now have all the essential skills to format text in Excel if you have completed the previous three lessons. Congratulations!

If you had any problems completing this module or think some details need more explanation, please let us know. We also welcome any other feedback.
Send Feedback