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