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 training courses uk - Excel Headings
excel training courses uk - Excel Headings
Resolved · Low Priority · Version Standard
Carol has attended:
Excel Introduction course
Excel Headings
Could you please tell me how to keep the heading at the top of the page while I'm working on the spreadsheet.
I have to keep scrolling up and down to see which column I am entering data into.
Thank you
RE: Excel Headings
Hi Carol
Thank you for your question.
If you select the first cell in the row underneath the headings you want to see when you scroll down the page (e.g. if your headings are in row 1, select cell A2). Then go to Window - Freeze Panes and you should now find that when you scroll down the spreadsheet the headings remain visible.
Amanda
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:Shortcuts for working with named ranges in ExcelIf you are working with or creating named ranges in your spreadsheets, then you may find the following shortcut keys useful. |