Microsoft Office Excel Lesson 7

Formatting Cells

All cell content uses the same formatting by default, which can make it difficult to read a workbook with a lot of information. Basic formatting can customize the look and feel of your workbook, allowing you to draw attention to specific sections and making your content easier to view and understand. You can also apply number formatting to tell Excel exactly what type of data you’re using in the workbook, such as percentages (%), currency ($), and so on.

Font Formatting

To change the font By default, the font of each new workbook is set to Calibri. However, Excel provides a variety of other fonts you can use to customize your cell text. In the example below, we’ll format our title cell to help distinguish it from the rest of the worksheet.
1. Select the cell(s) you wish to modify.
2. Click the drop-down arrow next to the Font command on the Home tab. The Font drop-down menu will appear.
3. Select the desired font. A live preview of the new font will appear as you hover the mouse over different options.

4. The text will change to the selected font.
  TIP: When creating a workbook in the workplace, you’ll want to select a font that is easy to read. Along with Calibri, standard reading fonts include Cambria, Times New Roman, and Arial.
To change the font size
1. Select the cell(s) you wish to modify.
2. Click the drop-down arrow next to the Font Size command on the Home tab. The Font Size drop-down menu will appear.
3. Select the desired font size. A live preview of the new font size will appear as you hover the mouse over different options.
4. The text will change to the selected font size.
To change the font color
1. Select the cell(s) you wish to modify.
2. Click the drop-down arrow next to the Font Color command on the Home tab. The Color menu will appear.
3. Select the desired font color. A live preview of the new font color will appear as you hover the mouse over different options.
4. The text will change to the selected font color.
To use the Bold, Italic, and Underline commands
1. Select the cell(s) you wish to modify.
2. Click the Bold (B), Italic (I), or Underline (U) command on the Home tab. In our example, we’ll make the selected cells bold.