Excel 2010 Bible

Part I: Getting Started with Excel

120

Tip
If you plan to distribute a workbook to other users, you should stick with the standard fonts that are included
with Windows or Microsoft Office. If you open a workbook and your system doesn’t have the font with which
the workbook was created, Windows attempts to use a similar font. Sometimes this attempt works okay, and
sometimes it doesn’t. n

Use the Font and Font Size tools on the Home tab of the Ribbon (or on the Mini toolbar) to change

the font or size for selected cells.

You also can use the Font tab in the Format Cells dialog box to choose fonts, as shown in Figure

6.3. This tab enables you to control several other font attributes that aren’t available elsewhere.

Besides choosing the font, you can change the font style (bold, italic), underlining, color, and

effects (strikethrough, superscript, or subscript). If you select the Normal Font check box, Excel

displays the selections for the font defined for the Normal style. I discuss styles later in this chap-

ter. See “Using Named Styles for Easier Formatting.”

FIGURE 6.3

The Font tab of the Format Cells dialog box gives you many additional font attribute options.

Figure 6.4 shows several different examples of font formatting. In this figure, gridlines were turned

off to make the underlining more visible. Notice, in the figure, that Excel provides four different

underlining styles. In the two non-accounting underline styles, only the cell contents are under-

lined. In the two accounting underline styles, the entire width of the cells is always underlined.