Microsoft Office Tutorials and References
In Depth Information
Finally, the range H23:H25 displays the percentage that each monitor contributes to
the overall profit from sales. Joan wants these values displayed with a percent sign and
two decimal places. To format a value as a percent, you can apply the Percent style. By
default, Excel does not display any decimal places with the Percent style; therefore, you
will need to increase the number of decimal places displayed.
To apply the Percent style and increase the number of decimal places:
1. Select the range H23:H25 .
2. Click the Percent Style button
on the Formatting toolbar. The values appear with
percent signs and without zeros.
3. Click the Increase Decimal button on the Formatting toolbar twice to display the per-
centages to two decimal places. Figure 3-4 shows the values in column H formatted with
percent signs and to two decimal places.
Applying the Percent style
values formatted with percent signs
and displayed to two decimal places
By displaying the percentages, you can quickly see that one monitor, the VX300,
accounts for almost half of the profit from monitor sales.
As you look over the sales figures, you see that one area of the worksheet still needs to be
formatted. The Units Sold column in the range E23:E26 still does not display the comma
separator you used with the sales figures. To fix a formatting problem like this one, you
can use the Format Painter button located on the Standard toolbar. When you use the
Format Painter option, you “paint” a format from one cell to another cell or to a range of
cells. This is a fast and efficient way of copying a format from one cell to another.
Copying Formatting Using the Format Painter
Select the cell or range whose formatting you want to apply to other cells.
To apply the formatting to one cell or an adjacent range of cells, click the Format Painter
button on the Standard toolbar, and then click the destination cell or drag the Format
Painter pointer over the adjacent range.
To apply the formatting to nonadjacent ranges, double-click the Format Painter button
on the Standard toolbar, and then drag the Format Painter pointer over the first range
and then over the other ranges you want to format.