Microsoft Office Tutorials and References
In Depth Information
EX 44
Excel Chapter 1 Creating a Worksheet and an Embedded Chart
To Format Numbers in the Worksheet
As previously noted, the numbers in the worksheet should be formatted to use a dollar-and-cents format, with
dollar signs in the fi rst row (row 4) and the total row (row 9). 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 cell B4 and drag
the mouse pointer to
cell G4 to select the
range B4:G4.
Accounting Number
Format button
Point to the
Accounting Number
Format button on the
Ribbon to display the
Enhanced ScreenTip
(Figure 1–65).
Enhanced
ScreenTip
range
B4:G4
selected
Figure 1–65
2
Click the Accounting Number Format
button on the Ribbon to apply the
Accounting Number Format to the
cells in the range B4:G4.
Select the range B5:G8 (Figure 1–66).
What effect does the Accounting
Number Format have on the
selected cells?
The Accounting Number Format
causes the cells to display with two
decimal places so that decimal places
in cells below the selected cells align
vertically. Cell widths are
automatically adjusted to accommodate the
new formatting.
Accounting Number
Format applied to
range B4:G4
range
B5:G8
selected
cell widths automatically
adjusted to accommodate
new formatting
Figure 1–66
Search JabSto ::




Custom Search