Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
(a) Unformatted Worksheet
(b) Formatted Worksheet
Figure 1– 29
3. Format the body of the worksheet. The body of the worksheet, range A3:N19,
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 rows 4 and 9 and the total rows (row 6 and 17); changes the styles of some rows;
adds underlining that emphasizes portions of the worksheet; and modies the column
widths to t the text in the columns and make the text and numbers readable.
BTW
Organizing Files
and Folders
You should organize and
store les in folders so that
you easily can nd the les
later. For example, if you
are taking an introductory
computer class called CIS 101,
a good practice would be
to save all Excel les in a
Excel folder in a CIS 101
folder. For a discussion of
folders and detailed examples
of creating folders, refer to
the office and Windows
chapter at the beginning of
this topic.
The remainder of this section explains the process required to format the
worksheet. 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.
Font Style, Size, and Color
The characters that Excel displays on the screen are a specic font, style, size, and
color. The font , or font face, denes 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 species 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 denes the color of the
characters. Excel can display characters in a wide variety of colors.
When Excel rst runs, 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.
Search JabSto ::




Custom Search