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

excel

ResolvedVersion 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 functions box quickly

If you want to do a formula using the paste functions box press SHIFT + F3.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.