What-If Analysis, Charting, And Working With Large Worksheets Page 33
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 169
To Determine Row Totals in Nonadjacent Cells
Error Messages
The following steps determine the row totals in column H. To determine the row
When Excel cannot
calculate a formula, it
totals using the Sum button, select only the cells in column H containing numbers in
displays an error message
adjacent cells to the left. If, for example, you select the range H14:H25, Excel will display
in a cell. These error
0s as the sum of empty rows in cells H16, H17, and H24.
messages always begin
with a number sign (#).
1
Select the range H14:H15. While holding down the
key, select the range H18:H23 and
CTRL
The more commonly
cell H25, as shown in Figure 3– 34.
occurring error messages
are as follows: #DIV/0!
2
Click the Sum button (Home tab | Editing group) to display the row totals in the selected
(tries to divide by zero);
ranges (Figure 3 –34).
#NAME? (uses a name
Excel does not recognize);
#N/A (refers to a value
Home tab
not available); #NULL!
Sum button
(specifi es an invalid
intersection of two areas);
#NUM! (uses a number
incorrectly); #REF (refers
to a cell that is not valid);
#VALUE! (uses an incorrect
argument or operand);
Editing group
and ##### (refers to
cells not wide enough to
display entire entry).
projected six-month
cost of goods sold,
gross margin,
expenses by category,
and operating income
Figure 3–34
To Unfreeze the Worksheet Titles and Save the Workbook
All the text, data, and formulas have been entered into the worksheet. The following
steps unfreeze the titles to allow you to work with the worksheet without frozen rows and
columns, and save the workbook using its current fi le name, Modern Music Shops Six-Month
Financial Projection.
1
+
Press
to select cell B13 and view the upper-left corner of the screen.
CTRL
HOME
2
Display the View tab and then click the Freeze Panes button (View tab | Window group)
to display the Freeze Panes gallery.
3
Click Unfreeze Panes in the Freeze Panes gallery to unfreeze the frozen columns and rows.
4
Display the Home tab and then click the Save button on the Quick Access Toolbar to save
the workbook.
+
Why does pressing
select cell B13?
CTRL
HOME
+
,
When the titles are frozen and you press
Excel selects the upper-left cell of
CTRL
HOME
the unfrozen section of the worksheet. For example, in Step 1 of the previous steps, Excel
+
selected cell B13. When the titles are unfrozen, pressing
selects cell A1.
CTRL
HOME
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education