Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
To change the unformatted worksheet in Figure 1– 26a on the previous page to the
formatted worksheet in Figure 1– 26b on the previous page, the following tasks must be
1. Change the font, change the font style to bold, increase the font size, and change
the font color of the worksheet titles in cells A1 and A2.
2. Center the worksheet titles in cells A1 and A2 across columns A through H.
3. Format the body of the worksheet. The body of the worksheet, range A3:H9,
includes the column titles, row titles, and numbers. Formatting the body of the
worksheet changes the numbers to use a dollars-and-cents format, with dollar
signs in the i rst row (row 4) and the total row (row 9); adds underlining that
emphasizes portions of the worksheet; and modii es the column widths to i t the
text in the columns and make the text and numbers readable.
The remainder of this section explains the process required to format the work-
sheet. Although the formatting procedures are explained in the order described above, you
should be aware that you could make these format changes in any order. Modifying the
column widths, however, usually is done last because other formatting changes may affect
the size of data in the cells in the column.
In general, use no more
than two font types in a
worksheet because the
use of more fonts can
make a worksheet difi cult
Font, Style, Size, and Color
The characters that Excel displays on the screen are a specii c font, style, size, and
color. The font , or font face, dei nes the appearance and shape of the letters, numbers, and
special characters. Examples of fonts include Calibri, Cambria, Times New Roman, Arial,
and Courier. Font style indicates how the characters are emphasized. Common font styles
include regular, bold, underline, and italic. The font size specii es the size of the characters
on the screen. Font size is gauged by a measurement system called points. A single point is
about 1/72 of one inch in height. Thus, a character with a point size of 10 is about 10/72
of one inch in height. The font color dei nes the color of the characters. Excel can display
characters in a wide variety of colors, including black, red, orange, and blue.
When Excel begins, the preset font for the entire workbook is Calibri, with a font
size, font style, and font color of 11–point regular black. Excel allows you to change the font
characteristics in a single cell, a range of cells, the entire worksheet, or the entire workbook.
Fonts and Themes
Excel uses default
recommended fonts based
on the workbook’s theme.
A theme is a collection of
fonts and color schemes.
The default theme is
named Ofi ce, and the two
default fonts for the Ofi ce
theme are Calibri and
Cambria. Excel, however,
allows you to apply any
font to a cell or range as
long as the font is installed
on your computer.
To Change a Cell Style
Excel includes the capability of changing several characteristics of a cell, such the font, font size, and font
color, all at once by assigning a predei ned cell style to a cell. Using the predei ned 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.