What-If Analysis, Charting, And Working With Large Worksheets Page 43
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
87What-If Analysis, Charting, and Working with Large Worksheets
Excel Chapter 3
EX 179
3
•
With the mouse
pointer still a block
plus sign with a
paintbrush, drag
through the range
A25:I25 to assign the
format of the source
cell, A13 in this case,
to the destination
range, A25:I25 in
this case.
•
Press the ESC key
format copied to range
A25:H25 and Currency
to stop the format
style applied to range
painter.
B25:I25
•
Apply the Currency
style to the range
B25:H25 to cause the
cells in the range
to appear with a
fl oating dollar sign
and two decimal
places and then scroll
Figure 3 – 49
the worksheet so that
Other Ways
column A is displayed (Figure 3 –49).
1. Click Copy button
(Home tab | Clipboard
Why does the Currency style need to be reapplied to the range B25:H25?
group), select cell, click
Paste button arrow
Sometimes, the use of the format painter results in unintended outcomes. In this case, the
(Home tab | Clipboard
changing of the background fi ll color and font color for the range B25:H25 resulted in the
group), click Formatting
loss of the Currency style because the format being copied did not included the Currency
icon on Paste gallery
style. Reapplying the Currency style to the range results in the proper number style, fi ll color,
2. Right-click cell, click
Copy, right-click cell,
and font color.
click Formatting icon on
shortcut menu
To Format the What-If Assumptions Table
and Save the Workbook
Painting a Format to
The last step to improving the appearance of the worksheet is to format the
Nonadjacent Ranges
Double-click the Format
What-If Assumptions table in the range A1:B8. The specifi cations in Figure 3– 40 on page
Painter button (Home tab
EX 173 require an 8-point italic underlined font for the title in cell A1 and 8-point font in
| Clipboard group) and
the range A2:B8. The following steps format the What-If Assumptions table.
then drag through the
nonadjacent ranges to
1
+
Press
to select cell A1.
CTRL
HOME
paint the formats to the
ranges. Click the Format
2
Click the Font Size button arrow (Home tab | Font group) and then click 8 in the Font Size
Painter button (Home
list to decrease the font size of the selected cell.
tab | Clipboard group) to
deactivate it.
3
Click the Italic button (Home tab | Font Group) and then click the Underline button
(Home tab | Font group) to italicize and underline the text in the selected cell.
4
Select the range A2:B8, click the Font Size button arrow (Home tab | Font group) and
then click 8 in the Font Size list to apply a smaller font size to the selected range.
5
Select the range A1:B8 and then click the Fill Color button (Home tab | Font group) to
apply the most recently used background color to the selected range.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education