What-If Analysis, Charting, And Working With Large Worksheets Page 22
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 158
Excel Chapter 3
What-If Analysis, Charting, and Working with Large Worksheets
1
View tab
•
Scroll the worksheet to ensure that
Excel displays row 10 as the fi rst row
Freeze Panes button
and column A on the screen.
•
Select cell B13 to select the cell on
Freeze Panes
which to freeze panes.
command
•
Display the View tab and then click
the Freeze Panes button (View
Freeze Panes gallery
tab | Window group) to display
the Freeze Panes gallery
(Figure 3 – 18).
cell below column
titles and to the
right of row titles
Why should I ensure that
to freeze
row 10 is the fi rst row
displayed?
Before freezing the titles, it is
important that Excel display the fi rst
row that you want frozen as the
fi rst row displayed. For example,
if cell B13 was selected while
displaying row 1, then Excel would
Figure 3 – 18
freeze the what-if assumptions and
only show a few rows of data in the Six-Month Financial Project area of the worksheet.
To ensure that you can view as much data as possible, always scroll to a row that maximizes
the view of your important data before freezing panes.
2
•
Click Freeze Panes in the Freeze
Panes gallery to freeze rows and
row titles in column A
columns to the left and above
will remain on the
screen when scrolling
the selected cell, column A and
right
rows 10 through 12 in this case
(Figure 3 – 19).
What happens
after I click the
column titles in fi rst
Freeze Panes
twelve rows will
remain on the screen
command?
when scrolling down
Excel displays
a thin black line on the right side
of column A, indicating the split
thin black lines indicate
between the frozen row titles
border of frozen rows
and columns
in column A and the rest of the
worksheet. It also displays a thin
black line below row 12, indicating
the split between the frozen column
titles in rows 10 through 12 and the
rest of the worksheet (Figure 3 – 19).
Figure 3 – 19
ADVERTISEMENT
0 votes
Related Articles
Related forms
Related Categories
Parent category: Education