Microsoft Office Tutorials and References
In Depth Information
Managing Worksheet Views
Freezing Row and
Column Headings
One of the most annoying things about working
with a large worksheet, such as a worksheet with
lots of rows, is that you can easily scroll down
and out of view of the column headings. At that
point, you will find yourself staring at lots of
unlabeled data, trying to decipher what it all
means. Without the column headings to guide
you, this can be quite difficult at times. The same
thing holds true if your worksheet uses row labels,
and you scroll to the right and out of sight of
them. One way to solve this problem is to freeze
the row and/or column headings in place, so
you can scroll down or to the right as far as you
like, and still identify what it is you’re looking at.
Using Full Screen
When you change to Full Screen view (by clicking
the Full Screen button on the View tab), the
current view settings are retained, but the Ribbon,
Quick Access Toolbar, Zoom slider, and view
buttons are removed to maximize viewing space,
as seen in Figure 6-30. The worksheet tabs are
still displayed along the bottom of the window
so you can switch from one sheet to another.
To exit Full Screen view, press Esc.
To freeze row and column headings, click a cell
below the column headings and to the right of
any row headings you want to freeze. Then click
the Freeze Panes button on the View tab and
select Freeze Panes. A dark line appears just
above and to the left of the cell you clicked—
these lines mark the “frozen” area of the sheet
as shown in Figure 6-31. After freezing row and
column headings, scroll down or to the right to
view the data you want; the headings always stay
in view. Here I split the screen to freeze the
column headings and to keep the customer names
in view, and then I scrolled to the right in the
lower-right pane to view the amount of that
customer’s last purchase. To unfreeze row and
column headings, click the Freeze Panes button
on the View tab and select Unfreeze Panes.
Figure 6-30
Full Screen view maximizes the viewing
area of the worksheet.
Because the zoom slider is removed when
you change to Full Screen view, you may
want to adjust the zoom before entering
this view.
Search JabSto ::

Custom Search