What-If Analysis, Charting, And Working With Large Worksheets Page 41
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 177
To Assign Cell Styles to Nonadjacent Rows and Colors to a Cell
Toggle Commands
Many of the commands
on the Ribbon, on
The next step to improving the appearance of the worksheet is to format the
the galleries, and the
heading in row 12 and the totals in rows 15, 23, and 25. The following steps format the
shortcut keys function
heading in row 13 with the Heading 3 cell style and the totals in rows 15, 23, and 25 with
as toggles. For example,
the Total cell style. Cell A13 also is formatted with a background color and font color.
if you click the Freeze
Panes command on the
1
Select the range A12:I12 and apply the Heading 3 cell style.
Freeze Panes gallery, the
command changes to
2
Select the range A15:I15 and while holding down the
key, select the ranges A23:I23
CTRL
Unfreeze Panes the next
and A25:I25.
time you view the gallery.
These types of commands
3
Apply the Total cell style to the selected nonadjacent ranges.
work like on-off switches
or toggles.
4
Select cell A13, click the Fill Color button arrow (Home tab | Font group), and then click
the Purple, Accent 2, Darker 25% color (column 6, row 5) in the Fill Color gallery.
5
Click the Font Color button arrow (Home tab | Font group) and then click the White,
Work Days
Background 1 color (column 1, row 1) in the Font Color gallery (Figure 3 –46).
Assume that you have
two dates, one in
cell A1 and the other in
cell A2. Assume further
that the date in cell A1
is your starting date
and the date in cell A2
is the ending date. To
calculate the work days
between the two dates
(excluding weekends), use
the following formula:
=NETWORKDAYS(A1, A2).
For this function to work,
make sure the Analysis
ToolPak add-in is installed.
You can install it on the
font color and fi ll
color changed
Add-Ins page of the Excel
Heading 3 cell
style applied
Options dialog box.
The Fill and Font
Color Buttons
You may have noticed
Total cell style
that the color bar at the
applied
bottom of the Fill Color
and Font Color buttons
(Home tab | Font group)
(Figure 3– 45) changes to
the most recently selected
color. To apply this same
color to a cell background
or text, select a cell and
then click the Fill Color
button to use the color as
a background or click the
Font Color button to use
Figure 3 – 46
the color as a font color.
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education