Excel 2019 Bible

(singke) #1

Chapter 5: Formatting Worksheets


55


Use the Font and Font Size tools in the Font group 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 5.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), underlin-
ing, 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. We
discuss styles later in this chapter (see “Using Named Styles for Easier Formatting”).


FIGURE 5.3


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


Figure 5.4 shows several 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 nonaccounting underline styles, only the cell contents are under-
lined. In the two accounting underline styles, the entire width of the cells is always underlined.

Free download pdf