How to Scroll Past Frozen Panes in Excel
Microsoft Excel has had the ability to freeze panes since the '95 version. Freezing panes lets you define fixed areas on the spreadsheet, such as the leftmost column or the top row, so that the titles of particular data rows, or column headers are always visible, even if you're scrolling through a very large data set. Excel 2010 places the controls for freezing cells and frames in the "View" tab of the Ribbon interface. In prior versions it was in the Window menu.
Other People Are Reading
Instructions
-
-
1
Open Excel and open the spreadsheet that you want to freeze panes on.
-
2
Select a cell that is one column to the right and one row below the demarcation point you want to freeze in view. For example, if you want to freeze columns A and B, and row 1, you would select cell C2 for this purpose. You can also select an entire row or an entire column -- just make sure it's one row or column past where you want the edge of your frozen frames to lie.
-
-
3
Click on the "View" tab and select "Freeze Panes" from the Window section of the Ribbon. The fly out menu will give you an option to Freeze Panes. Select that option.
-
4
Scroll through the spreadsheet by clicking the sliders on the bottom of the window or on the right hand size, or by scrolling through with the wheel on your mouse, if your mouse is so equipped.
-
5
Unfreeze panes by clicking on a cell in the frozen area, and clicking on the icon that says "Freeze Panes" -- the top option will have changed to "Unfreeze Panes" on the fly out menu.
-
1
