Formatting Text in Excel

Formatting Text in Excel

Making great looking spreadsheets require you to format text in excel. It is very simple but useful. If you know how to format text in other programs such as Word, you will already know how to do most of the formatting in Excel.

Learn how to underline, bold, italicize, change font size, and change font color of text.

Let's learn how to format text in Microsoft Excel.

How to Bold Text in Excel:
Image Tutorial

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

Or (instead of step 4)
5. Click Format on the menu bar.
6. Click Cells.
7. The format cells window will pop-up. Click the "Font" tab.
8. Click on Bold.
9. Click OK.

How to Underline Text in Excel:
Image Tutorial

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

Or (instead of step 4)
5. Click Format on the menu bar.
6. Click Cells.
7. The format cells window will pop-up. Click the "Font" tab.
8. Click the arrow to the right of "underline style".
9. Click on the style of line you would like.
10. Click OK.

How to Italicize Text in Excel:
Image Tutorial

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

Or (instead of step 4)
5. Click Format on the menu bar.
6. Click Cells.
7. The format cells window will pop-up. Click the "Font" tab.
8. Click on Italic.
9. Click OK.

How to Change Font Size of 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 font you would like to resize.
4. Click on the arrow beside the "12" on the formatting toolbar. Select the new size.

Or (instead of step 4)
5. Click Format on the menu bar.
6. Click Cells.
7. The format cells window will pop-up. Click the "Font" tab.
8. Click the desired size.
9. Click OK.

How to Change Font Colour of 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 change colour.
4. Click on the arrow beside the "A" with the thick underline (current colour of the text) on the formatting toolbar. Select a new colour.

Or (instead of step 4)
5. Click Format on the menu bar.
6. Click Cells.
7. The format cells window will pop-up. Click the "Font" tab.
8. Click the desired font colour.
9. Click OK.

How to Change the Font of 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 change font face.
4. Click on the arrow beside the "Times New Roman" (current font face) on the formatting toolbar. Select the new font.

Or (instead of step 4)
5. Click Format on the menu bar.
6. Click Cells.
7. The format cells window will pop-up. Click the "Font" tab.
8. Click the desired font face. We will choose "Arial".
9. Click OK.

Alright, so now you basically know how to format text in any microsoft program and many other programs. There is no reason to have sloppy looking documents anymore.

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