Microsoft Office Tutorials and References
In Depth Information
Managing Worksheet Views
Full Screen: Choose View>Workbook
Views>Full Screen. As shown in Figure 11-17,
you see only the worksheet itself with its row
and column headings, worksheet tabs, and
the title bar. The Ribbon, Quick Access
Toolbar, and the Status bar are hidden. Press
the Escape key. Excel returns to Normal view.
Typically, when you press Ctrl+Home,
Excel takes you to cell A1, but when you
have the Freeze Panes feature active, Excel
takes you to the cell just below and to the
left of the frozen headings.
Choose what you want to freeze:
Columns: Select the column to the right of
the columns you want to freeze. For
example, click cell B1 to freeze only column A.
Rows: Select the row below the rows you
want to freeze. For example, click cell A4 to
freeze rows 1, 2, and 3.
Columns and rows: Click the cell below
the rows and to the right of the columns
you want to freeze. For example, click cell
B2 to freeze both column A and row 1.
Full Screen view.
Freezing Worksheet Titles
When working with a long or wide list, as you add
more data you might lose track of which column
or row you are entering data into. It would be
helpful if you could see which column or row label
you are working with. You can freeze the column
headings and row labels so they remain visible no
matter where you are working in your worksheet.
Current Worksheet Only
Freezing panes affects only the current
worksheet. If you want to freeze other
worksheets, you must select them individually
and freeze them.
Choose View>Window>Freeze Panes>Freeze Panes.
A thin black line appears to separate the sections.
As you see in Figure 11-18, as you scroll down and
to the left, row 1 and columns A and B remain
visible even though you see rows 40 through 62 in