Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
To Change a Cell Style
Excel includes the capability of changing several characteristics of a cell, such as the font, font size, and
font color, all at once by assigning a predened cell style to a cell. Why? Using the predened styles that Excel
includes provides a consistent appearance to common portions of your worksheets, such as worksheet titles, worksheet subtitles,
column headings, and total rows. The following steps assign the Title cell style to the worksheet title in cell A1.
• Tap or click cell A1 to make cell A1 the active cell.
• Tap or click the Cell Styles button (HOME tab | Styles group) to display the Cell Styles gallery (Figure 1– 30).
Figure 1– 30
• If you are using a mouse, point to the Title cell style in the Titles and Headings area of the Cell Styles gallery to see
a live preview of the cell style in the active cell (Figure 1– 31).
Can I use live preview on a touch screen?
Live preview is not available on a touch screen.
• If you are using a mouse, point to several other cell styles in the Cell Styles gallery to see a live preview of other cell
styles in cell A1.
Title cell style
live preview of Title
cell style in cell A1
Figure 1– 31