How Do I:
Freeze row/s or column/s?
Unfreeze row/s or column/s?
Split the screen - pane control?
To freeze top and side labels (NOTE: Students do not normally need to freeze cells, but teachers may use the skill when dealing with a large spreadsheet.)
-
Click in the cell below the row and to the right of the column you want to freeze.
-
On the menu, click Format - Freeze Titles
NOTE: To unfreeze, repeat Format - Freeze Titles to uncheck Freeze Titles.
-
You will see fine lines bordering the frozen row/s and column/s. Now when you scroll, those areas will remain stationary.
-
To freeze only a row, in step #1 above, click in the left-most cell below the row.
-
To freeze only a column, in step #1 above, click in the top cell to the right of the column.
Pane Control (NOTE: As with freeze, students do not normally need to split screens, but teachers may use the skill when dealing with a large spreadsheet.)
To "split" the screen, go to the gray bar beside the Zoom Box at the bottom left-hand corner and put your mouse cursor on it. The cursor will change to the Adjust cursor and you can click and drag right until you are at the line between the first and second columns. Let go of the mouse button and you will have two windows that can be scrolled, but have the very same information. If you only scroll in the second window, you will always be able to see the first column.
Your window will look something like this.
To "split" the screen horizontally, go to the gray bar underneath the Close Box at the top right-hand corner and put your mouse cursor on it. The cursor will change to the Adjust cursor and you can click and drag down until you are at the line below the one you want to hold. Let go of the mouse button and you will have two windows that can be scrolled, but have the very same information. If you only scroll in the bottom window, you will always be able to see the top row/s.
Your window will look something like this.
To Remove the Split Screen Bar, click, hold, and drag the bar toward the outer edge of the window.
Last edited 6/4/01