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 » Panes
Panes
Resolved · Low Priority · Version 2003
Humphrey has attended:
Excel Introduction course
PowerPoint Intermediate Advanced course
Panes
Pls could you tell me how to freeze panes?
Thanks
RE: Panes
Hello Humphrey
Thank you for your question and welcome to the forum.
Firstly you need to select a cell which represents the position in the spreadsheet that you want to have the freeze panes set at.
For example:
- If you want to see row 1 when you scroll down, select cell A2.
-If you want to see column A when you scroll across, select cell B1.
- If you want to see both row 1 and column A when you scroll, select cell B2 (the cell that is both below the row/s you wish to see when scrolling; and to the right of the column/s you wish to see when scrolling).
Then go to Window - Freeze Panes.
I hope this helps.
Kind regards
Amanda
Mon 26 Oct 2009: Automatically marked as resolved.
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:Outlining - Grouping rows or columnsHighlight want you want to group and press ALT + SHIFT + left cursor arrow |