excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · 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


 

Excel tip:

Paste a web address into the hyperlink address field

If 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.

View all Excel hints and tips


Server loaded in 0.07 secs.