Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
Identify how to format various elements of the worksheet.
To change the unformatted worksheet in Figure 1–46a to the formatted worksheet in
Figure 1–46b, the following tasks must be completed:
1. Change the font type, change the font style to bold, increase the font size, and change
the font color of the worksheet titles in cells A1 and A2. These changes make the
worksheet title prominently display to the user and inform the user of the purpose of the
2. Center the worksheet titles in cells A1 and A2 across columns A through G.
3. Format the body of the worksheet. The body of the worksheet, range A3:G9, 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 ﬁ rst row (row 4)
and the total row (row 9); adds underlining that emphasizes portions of the worksheet;
and modiﬁ es the column widths to make the text and numbers readable.
The remainder of this section explains the process required to format the worksheet.
Although the format 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.
Font Type, Style, Size, and Color
The characters that Excel displays on the screen are a speciﬁ c font type, style, size,
and color. The font type , or font face, deﬁ nes the appearance and shape of the letters,
numbers, and special characters. Examples of font types include Calibri, Cambria, Times
New Roman, Arial, and Courier. Font style indicates how the characters are emphasized.
Common font styles include regular, bold, underline, or italic. The font size speciﬁ 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 deﬁ 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 type 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
In general, use no more
than two font types in a
Fonts and Themes
Excel uses default
based on the workbook’s
theme. A theme is a
collection of fonts and
color schemes. The
default theme is named
Ofﬁ ce, and the two
recommended fonts for
the Ofﬁ 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