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 » Excel
Excel
Resolved · Low Priority · Version 2003
Madeleine has attended:
Excel Introduction course
Excel
How do i freeze my headings as i scroll down?
RE: Excel
Highlight the row underneath your heading, then go window > freeze panes
this should do the trick.
RE: Excel
Hi Madeleine,
If you have row headings you want to freeze e.g. headings in cells A1 to F1, then place your cursor in cell A2 and use the Window, Freeze panes command.
If you have a column you want to freeze such as names or departments in column A, place your cursor in cell B2 and Feeze panes. This will freeze the row headings above and column A.
I hope this answers your question.
Regards
Simon
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:Paste a web address into the hyperlink address fieldIf you copy a web address the only way to paste into the address field of the hyperlink box is to use CTRL + V. Right click paste does not work. |