Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Freeze panes
Resolved · Low Priority · Version Standard
Susan has attended:
Excel Introduction course
How do you freeze panes vertically and horizontally?
Hi Susan, Thank you for your post, welcome to the forum, in answer to your question, to freeze panes in a worksheet consider the location of the active cell, when you freeze a pane; you lock the cells to the left of and above this cell. To freeze the area required, select the cell as per above, then go to the menu command Window> Freeze Panes, you can now scroll left and right and up and down in your worksheet with the selected area always in view. To remove the Freeze go to the command Window> Un Freeze panes.
Take a moment to try the other option which is Split this allows you to view different areas of the worksheet at the same time. I hope that helps, best regards Pete.
|
Excel tip:Select blank cells automaticallyGet Excel to find any blank (empty) cells in a region for you by: |
We'll call during UK business hours
Server loaded in 0.08 secs.