Labelling columns in Excel

  graham√ 10:34 15 Jun 03
Locked

I have used row 1 to label columns, but naturally they scroll up with the contents. Is there a way to keep them on top, or is there another way to label columns?

  VoG® 10:35 15 Jun 03

Position cursor in Row 2. Window/Freeze panes.

  graham√ 10:40 15 Jun 03

I knew there would be an easy way! Thanks, VoG®.

  graham√ 10:51 15 Jun 03

I have to do that every time I open the sheet, right? Or can I save the setting?

  VoG® 11:00 15 Jun 03

It will save the setting until you reverse it by Window/Unfreeze panes.

Incidentally, let's say you have labels in Column A that you want to be always visible when you scroll across, then position the cursor in B2, Window/Freeze Panes will "fix" those as well.

  VoG® 11:01 15 Jun 03

Assuming that you've saved the file after making the setting, of course.

  graham√ 11:12 15 Jun 03

I've tried 'save as', and 'save workspace', but if I close Excel and then re-open the worksheet the 'freeze panes' has gone.

  VoG® 11:16 15 Jun 03

click here

I've never tried saving a file in a workspace so didn't know about this, sorry.

  VoG® 11:19 15 Jun 03

Also click here

  graham√ 12:18 15 Jun 03

Thanks for trying. It's no problem to freeze the panes each time, the cat gets impatient to see her weight!

  wee eddie 13:52 15 Jun 03

Is the Excel file stored else where, on a server perhaps.

Something like that would have the effect of storing your workings but not any changes to the worksheets settings

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

Amazon Fire HD 8 review: A brilliant combination of function and value – with one massive caveat

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

How to create an introvert-friendly workplace

Apple Watch 2 review | Apple Watch Series 2 review: New Apple Watch is faster, brighter, water-resit…