Microsoft Office Tutorials and References
In Depth Information
EX 182
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
To Freeze Column and Row Titles
The following steps use the Freeze Panes button on the View tab on the Ribbon to freeze the worksheet title
and column titles in rows 1, 2, and 3, and the row titles in column A.
1
Press CTRL + HOME to
select cell A1 and
ensure that Excel
displays row 1 and
column A on the
screen.
View tab
Freeze Panes
button
Freeze
Panes
command
Select cell B4.
Click the View tab
on the Ribbon and
then click the
Freeze Panes
button on the
Ribbon to
display the
Freeze Panes
gallery (Figure 3–18).
Why is cell A1
selected fi rst?
Before freezing the titles, it is important that Excel displays cell A1 in the upper-left corner of the
screen. For example, if cell B4 was selected without fi rst selecting cell A1 to ensure Excel displays
the upper-left corner of the screen, then Excel would freeze the titles and also hide rows 1 and 2.
Excel thus would not be able to display rows 1 and 2 until they are unfrozen.
cell below column
titles and to the
right of row titles
to freeze
Freeze Panes gallery
Figure 3–18
2
Click Freeze Panes in the Freeze
Panes gallery to freeze column A
and rows 1 through 3 (Figure 3–19).
What happens after I click the
Freeze Panes
command?
Excel displays
a thin black
line on the
right side of column A, indicating
the split between the frozen
row titles in column A and the rest
of the worksheet. It also displays a
thin black line below row 3,
indicating the split between the
frozen column titles in rows 1
through 3 and the rest of the
worksheet (Figure 3–19).
row titles in column
A will remain on
the screen when
scrolling right
column titles in
fi rst three rows will
remain on the screen
when scrolling down
thin black lines
indicate border of
frozen rows and
columns
Figure 3–19
Other Ways
1. Press ALT+W , F
 
Search JabSto ::




Custom Search