Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pane freeze
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Pane freeze
Resolved · Low Priority · Version 2010
Reply Tue 12 Jul 2011, 16:40Delegate Sid said...
Sid has attended:
Excel Introduction course
Excel Intermediate course
Pane freeze
i would like to know how to freeze/unfreeze a pane
For upcoming training course dates see: Pricing & availability
RE: pane freeze
Hi Sid
Thank you for your question
First select the cell that is immediately below the last row you want frozen and immediately to the right of the last column you want frozen.
Then go to the View ribbon and click on freeze panes in the window group
To unfreeze go to the View ribbon and click on unfreeze panes in the window group
Regards
Stephen
Tue 19 Jul 2011: Automatically marked as resolved.
|