Microsoft Office Tutorials and References
In Depth Information
Inserting and Deleting Cells in a Worksheet
• Excel displays row 10 as the i rst row
and column A on the screen.
Scroll the worksheet to ensure that
Freeze Panes button
Select cell B13 to select the cell on
which to freeze panes.
• the Freeze Panes button (View
tab | Window group) to display
the Freeze Panes gallery
(Figure 3 – 18).
Why should I ensure that
row 10 is the i rst row
Before freezing the titles, it is
important that Excel display the i rst
row that you want frozen as the
i rst row displayed. For example,
if cell B13 was selected while
displaying row 1, then Excel would
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.
Display the View tab and then click
Freeze Panes gallery
cell below column
titles and to the
right of row titles
Figure 3 –18
Click Freeze Panes in the Freeze
Panes gallery to freeze rows and
columns to the left and above
the selected cell, column A and
rows 10 through 12 in this case
(Figure 3 – 19).
after I click the
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 12, indicating
the split between the frozen column
titles in rows 10 through 12 and the
rest of the worksheet (Figure 3 – 19).
row titles in column A
will remain on the
screen when scrolling
column titles in i rst
twelve rows will
remain on the screen
when scrolling down
thin black lines indicate
border of frozen rows
Figure 3 –19