Tue 23 Oct 2007, 15:33Delegate Carol said...
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
Tue 23 Oct 2007, 16:13Trainer Amanda said...
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
