Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
Formatting the Worksheet
Although the worksheet contains the appropriate data, formulas, and functions, the text
and numbers need to be formatted to improve their appearance and readability.
In Chapter 1, cell styles were used to format much of the worksheet. This section
describes how to change the unformatted worksheet in Figure 2 – 30a to the formatted
worksheet in Figure 2 – 30b using a theme and other commands on the Ribbon. The
colors and fonts that are used in the worksheet shown in Figure 2–30b are those
that are associated with the Trek theme.
(a) Unformatted
Worksheet
thick box border
surrounds worksheet
title and subtitle
Title cell style
applied to title
and subtitle
orange
background
column titles
centered
row height
increased
Heading 3 cell
style applied
to row 3
numbers over 70 displayed
with orange background
and white font color
Comma
style format
Total cell style
applied to row 13
dates formatted
to mm/dd/yy
style
row height
increased
data centered
in cells
Currency
style format
Percent
style format
(b) Formatted
Worksheet
column width changed
Figure 2 – 30
 
Search JabSto ::




Custom Search