MS Excel help

  lonemascot 22:49 24 Jan 08
Locked

I have a spreadsheet where i have values in loads of columns at the top the page.

as i scroll down the page these disappear so when i come to input data further down i don't know what column to put it in unless i scroll up again.

how can i keep the headings to float down with me as i scroll?

  VoG II 22:53 24 Jan 08

Click in A2 (or wherever your headings end).Window > Freeze Panes.

  Jim_F 22:57 24 Jan 08

Click the first data Row number on the left hand side so that it highlights the full Row.

The click 'Freeze Panes' under the Windows Menu in Excel

  lonemascot 22:58 24 Jan 08

Ah thats it, I knew i could count on this forum for answers.

Thanks buddy

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…