What-If Analysis, Charting, And Working With Large Worksheets Page 57
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 193
Renaming and Reordering the Sheets
and Coloring their Tabs
The fi nal step in creating the workbook is to reorder the sheets and modify the tabs at the
bottom of the screen.
To Rename the Sheets and Color Their Tabs
The following steps rename the sheets and color the sheet tabs.
1
Change the sheet tab color of the 3-D Pie Chart sheet to Orange, Accent 6 (column 10, row 1).
2
Double-click the tab labeled Sheet1 at the bottom of the screen.
Six-Month Financial Projection
3
Type
as the new sheet name and then
press the
key.
ENTER
4
Change the sheet tab color of the Six-Month Financial Projection sheet to Pink, Accent 1
(column 5, row 1) and then select cell D8 (Figure 3–72).
tab color shows as
3-D Pie Chart tab
pink underline when
colored orange
sheet is active
Figure 3 –72
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education