Labelling columns in Excel

  graham√ 10:34 15 Jun 2003
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 2003

Position cursor in Row 2. Window/Freeze panes.

  graham√ 10:40 15 Jun 2003

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

  graham√ 10:51 15 Jun 2003

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

  VoG® 11:00 15 Jun 2003

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 2003

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

  graham√ 11:12 15 Jun 2003

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 2003

click here

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

  VoG® 11:19 15 Jun 2003

Also click here

  graham√ 12:18 15 Jun 2003

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 2003

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.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Camera tips to take better iPhone photos

Les meilleures applications de covoiturage 2017