What-If Analysis, Charting, And Working With Large Worksheets Page 38
ADVERTISEMENT
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87EX 174
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
To Assign Formats to Nonadjacent Ranges
The numbers in the range B13:H25 are to be formatted as follows:
1. Assign the Currency style with a fl oating dollar sign to rows 13, 15, 18, 23, and 25.
2. Assign a Comma style to rows 14 and 19 through 22.
The following steps assign formats to the numbers in rows 13 through 25.
1
Home tab
•
Select the range
B13:H13 as the fi rst
range to format.
•
While holding down
the
key, select
CTRL
the nonadjacent
ranges B15:H15,
B18:H18, B23:H23, and
sample of format
B25:H25, and then
Currency style to appear
release the
key
CTRL
with two decimal places,
dollar sign, and negative
to select nonadjacent
numbers in parentheses
ranges.
•
Click the Format Cells:
Number Dialog Box
Launcher (Home tab |
Number group) to
display the Format
OK button
Cells dialog box.
•
Click Currency in the
Category list (Format
Cells dialog box), if
necessary select 2 in
the Decimal places
box, if necessary click $
in the Symbol list to
ensure a dollar sign
Figure 3 – 41
shows in the cells to
be formatted, and
click the black font color ($1,234.10) in the Negative numbers list to prepare the desired
Currency style for the selected ranges (Figure 3–41).
Why was the particular style chosen for the negative numbers?
In accounting, negative numbers often are shown with parentheses surrounding the value
rather than with a negative sign preceding the value. Thus, the format (1,234.10) in the
Negative numbers list was clicked. The data being used in this chapter contains no negative
numbers. You must select a format for negative numbers, however, and you must be
consistent if you are choosing different formats in a column; otherwise, the decimal points
may not line up.
Why is the Format Cells dialog box used to create the format for the ranges in this step?
The requirements for this worksheet call for a fl oating dollar sign. To assign a Currency style
with a fl oating dollar sign, use the Format Cells dialog box rather than the Accounting Style
button (Home tab | Number group), which assigns a fi xed dollar sign.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education