Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
Formatting Numbers Using the Ribbon
As shown in Figure 2 – 27b on page EX 90, the worksheet is formatted to
resemble an accounting report. For example, in columns D through G and I, the
numbers in the rst row (row 4), the totals row (row 13), and the rows below the
totals (rows 14 through 16) have dollar signs, while the remaining numbers (rows 5
through 12) in columns D through G and column I do not.
To Apply an Accounting Number Format and
Comma Style Format Using the Ribbon
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
The following steps assign formats using the ‘Accounting Number Format’ button and the Comma Style
button. The accounting number format is applied to the currency amounts in rows 4 and 13. The comma style
format is applied to the range E5:G12 and to range I5:I12, and to column C (Hours Worked). Why? This gives
the worksheet a more professional look.
• Select the range to contain the
accounting number format, cells
D4:G4 in this case.
• While holding down the CTRL
key, select cell I4, the range
E13:G13, and cell I13 to select the
nonadjacent ranges and cells.
• Tap or click the ‘Accounting
Number Format’ button (HOME
tab | Number group) to apply the
accounting number format with
xed dollar signs to the selected
nonadjacent ranges (Figure 2 – 38).
and ranges selected
What is the effect of applying the
accounting number format?
The ‘Accounting Number Format’
button assigns a xed dollar sign
to the numbers in the ranges. In each
cell in these ranges, Excel displays the dollar sign to the
far left with spaces between it and the rst digit in the cell.
Figure 2 – 38
• Select the ranges to contain the
comma style format, cells D5:G12
and I5:I12 in this case.
• Tap or click the Comma Style
button (HOME tab | Number
group) to assign the comma style
format to the selected ranges
(Figure 2 – 39).
Figure 2 – 39