Microsoft Office Tutorials and References
In Depth Information
Formatting the numbers
FIGURE 12.6
Your worksheet, after creating the formulas
12
Formatting the numbers
The values in the worksheet are diffi cult to read because they aren’t formatted. In this
step, you apply a number format to make the numbers easier to read and more consistent in
appearance:
1. Select the numbers by dragging from cell B2 down to cell B13. Don’t drag the fi fill
handle this time, though, because you’re selecting cells, not fi lling a range.
2. On the Ribbon, click Home. In the Number group, click the drop-down Number
Format control (it initially displays General), and select Currency from the list.
The numbers now display with a currency symbol and two decimal places. Much
better, but the decimal places aren’t necessary for this type of projection.
3. Make sure the range B2:B13 is selected, choose Home Number, and click the
Decrease Decimal button. One of the decimal places disappears. Click that button
a second time, and the values are displayed with no decimal places.
Making your worksheet look a bit fancier
At this point, you have a functional worksheet, but it could use some help in the appearance
department. Converting this range to an “offi cial” (and attractive) Excel table is a snap:
1. Activate any cell within the range A1:B13.
2. Choose Insert Tables Table. Excel displays the Create Table dialog box to make
sure that it guessed the range properly.
3. Click OK to close the Create Table dialog box. Excel applies its default table
formatting and displays its Table Tools Design contextual tab.
Search JabSto ::




Custom Search