What-If Analysis, Charting, And Working With Large Worksheets Page 40
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 176
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
To Format the Worksheet Titles
The following steps emphasize the worksheet titles in cells A10 and A11 by changing the font, size, and color.
The steps also format all of the row headers in column A with a bold font style.
1
•
+
Press
to select cell A1
CTRL
HOME
and then click the column A heading
Bold button
to select the column.
•
Click the Bold button (Home tab |
Font group) to bold all of the data
in the selected column.
•
Select cell A10, click the Font Size
Font group
box arrow (Home tab | Font group),
and then click 36 in the Font Size
list to increase the font size of the
selected cell.
•
Select cell A11, click the Font Size
box arrow, and then click 18 in the
Font Size list to increase the font size
of the selected cell (Figure 3–44).
font size of cell A10
changed to 36 and
font size of cell A11
changed to 18
Figure 3 – 44
2
Home tab
Font Color
•
Select the range A10:I11 and then
button arrow
click the Fill Color button arrow
(Home tab | Font group) to display
the Fill Color gallery.
•
Click Purple, Accent 2, Darker 25%
(column 6, row 5) in the Fill Color
Font group
gallery to add a background color
Fill Color
button arrow
to the selected range.
•
Click the Font Color button arrow
(Home tab | Font group) and
then select White, Background 1
fi ll color and font
(column 1, row 1) in the Font Color
color of range
A10:I11 changed
gallery to change the font color of
the selected range (Figure 3– 45).
Figure 3 – 45
Other Ways
1. Right-click range, click
click Font tab to color
box) to color background
Format Cells on shortcut
font), click OK button
(or click Font tab to color
menu, click Fill tab
font), click OK button
+ 1,
2. Press
click Fill
CTRL
(Format Cells dialog box)
tab (Format Cells dialog
to color background (or
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education