98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Freezing Panes
Freezing Panes
Resolved · Low Priority · Version 2007
Lyndsay has attended:
Excel Intermediate course
Freezing Panes
I want a reminder on how to freeze panes
RE: Freezing Panes
If you want to freeze all rows above say Row 4. Click on the row header 4. When the whole row is selected choose 'windows' and 'Freeze Pane' the same process applies to unfreezing it.
If you want to freeze everything above and to the left just click on the cell (as opposed) to the row header and repeat the steps above.
Does that help?
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. |
Excel tip:Use shortcut keys to select rows or columnsMost users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that. |