Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
Formatting the Worksheet
The worksheet created thus far shows the i nancial projections for the six-month
period, from July to December. Its appearance is uninteresting, however, even though
some minimal formatting (formatting assumptions numbers, changing the column
widths, formatting the date, and formatting the Sparkline chart) was performed earlier.
This section will complete the formatting of the worksheet to make the numbers
easier to read and to emphasize the titles, assumptions, categories, and totals as shown
in Figure 3– 40.
Plan
Ahead
Identify how to format various elements of the worksheet.
A worksheet, such as the one presented in this chapter, should be formatted in the following
manner: (1) format the numbers; (2) format the worksheet title, column titles, row titles,
and total rows; and (3) format an assumptions table. Numbers in heading rows and total
rows should be formatted with a currency symbol. Other dollar amounts should be format-
ted with a Comma style. An assumptions table should be diminished in its formatting so
that it does not distract from the main calculations and data in the worksheet. Assigning
the data in an assumptions table a smaller font size would set it apart from other data
formatted with a larger font size.
14-point italic
underlined font
ranges A10:I11 and
A1:B8 have purple
background
font in range
A2:B8 is 8-point
36-point font
height of rows
10 through 12
are best i t
Comma style
Currency style
with l oating
dollar sign
Figure 3 – 40
 
Search JabSto ::




Custom Search