Saturday, January 15, 2011

How to Scroll Past Frozen Panes in Excel


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.

Blogger news