Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
4
Use Steps 1 and 2 to
format the range
A6:N6 and A17:N17
with the Total cell
style format.
Use Steps 1 and 2
to format the range
A19:N19 with
the Accent 1 cell
style format.
Use Steps 1 and 2
to format the range
A4:N4, A9:N9,
A11:N11, A13:N13,
A15:N15 with the
20% - Accent 1 cell
style format.
Use Steps 1 and 2
to format the range
A5:N5, A10:N10,
A12:N12, A14:N14, A16:N16 with the 40% -
Accent 1 cell style format (Figure 1– 46).
styles
applied to
all rows
Figure 1– 46
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
To Format Numbers in the Worksheet
Why? As previously noted, the numbers in the rst row and last row of each section should be formatted to use a
dollar-and-cents format, while the others use a comma format. Excel allows you to format numbers in a variety of
ways, and these methods are discussed in other chapters in this topic. The following steps use buttons on the
ribbon to format the numbers in the worksheet.
1
Select the range B4:N4.
Tap or click the
‘Accounting Number
Format’ button
(HOME tab | Number
group) to apply the
accounting number
format to the cells in
the selected range.
‘Accounting Number Format’
button (touch screens may not
have a separate ‘Accounting
Number Format’ button and
‘Accounting Number Format’
arrow)
accounting number
format applied to
range B4:N4
What if my
screen displays an
Accounting Number
Format menu?
If you are using a
touch screen, you may
not have a separate
‘Accounting Number Format’ button and ‘Accounting Number Format’ arrow.
In this case, select the desired option on the Accounting Number Format menu.
range B5:N5 selected
Figure 1– 47
Select the range B5:N5 (Figure 1– 47).
What effect does the accounting number format have on the selected cells?
The accounting number format causes the cells to be displayed with two decimal places so that decimal places in cells
below the selected cells align vertically. Cell widths are adjusted automatically to accommodate the new formatting.
 
Search JabSto ::




Custom Search