Microsoft Office Tutorials and References
In Depth Information
Freezing panes
Figure 6-18 With the window split, you can scroll each pane independently.
Note
Before clicking Window, Split or double-clicking one of the split bar icons, select a cell
in the worksheet where you want the split to occur. This splits the worksheet
immediately to the left or above the selected cell or both above and to the left. If cell A1
is active, the split occurs in the center of the worksheet. In Figure 6-17, we selected
cell B3 before choosing the Split command, which resulted in the split panes shown in
Figure 6-18.
With the window split into four panes, as shown in Figure 6-18, four scroll bars are available
(if not visible)—two for each direction. Now you can use the scroll bars to view columns
B through N without losing sight of the product headings in column A. In addition, when
you scroll vertically between rows 3 and 37, you always see the corresponding headings in
row 2.
After a window is split, you can reposition the split bars by dragging. If you are ready to
return your screen to its normal appearance, click the Split button again to remove all the
split bars. You can also remove an individual split by double-clicking the split bar or by
dragging the split bar to the top or right side of the window.
Freezing panes
After you split a window into panes, you can freeze the left panes, the top panes, or both
panes by clicking the View tab on the ribbon, clicking Freeze Panes, and selecting the
corresponding option, as shown in Figure 6-19. When you do so, you lock the data in the
Search JabSto ::




Custom Search