What-If Analysis, Charting, And Working With Large Worksheets Page 42
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 178
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
To Copy a Cell’s Format Using the Format Painter Button
Using the Format Painter, you can format a cell quickly by copying a cell’s format to another cell or a range of
cells. The following steps format cells A15 and the range A25:I25 using the Format Painter.
1
Format Painter
Home tab
•
If necessary, click cell
button
A13 to select a source
cell for the format to
paint.
•
Double-click the
Format Painter
block plus sign with
paintbrush mouse
button (Home tab |
Clipboard
pointer
group
Clipboard group)
and then move the
mouse pointer onto
the worksheet to
cell A13 selected
cause the mouse
pointer to change
to a block plus sign
with a paintbrush
(Figure 3 – 47).
marquee is displayed
around cell A13
Figure 3 – 47
2
•
Click cell A15 to
assign the format
of the source cell,
A13 in this case,
to the destination
cell, A15 in this case
(Figure 3 –48).
format of cell A13
copied to cell A15
Figure 3 – 48
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education