5

Does anyone know how to rename a column in google spreadsheets? Seems easy enough in excel. https://productforums.google.com/forum/#!topic/docs/ewnE52j57YU

I was hoping that ideally I could see what the column values refer to when the top of the column is out of sight. so if I'm at row 400, i can easily see that "column d" is the "math" column for instance. I don't see how these approaches helps achieve this visual aid?

3

If you don't want to use the column-name-in-the-first-row approach mentioned in the answer you have linked to, then you can:

  • Select the column
  • From the menu, choose Data > Names Ranges ...
  • Type in the column name
  • Press Done.

NB This works in Google Sheets files created since the "new" version was released, and older ones converted to the new format. I don't know if the feature is available in others - perhaps not, if you have difficulty finding it.

Worked example: here

| improve this answer | |
  • I was hoping that ideally I could see what the column values refer to when the top of the column is out of sight. so if I'm at row 400, i can easily see that "column d" is the "math" column for instance. I don't see how these approaches helps achieve this visual aid? – user3314418 Jun 7 '14 at 11:39
  • 2
    In that case, you should use the approach used in the article you have linked to, along with the View > Freeze Rows > Freeze 1 Row option – MaryC.fromNZ Jun 7 '14 at 19:26
  • 1
    you are amazing! i didn't see the freeze row option. thanks! – user3314418 Jun 8 '14 at 16:40
  • 1
    This doesn't seem to work anymore – Ben Leggiero Jun 28 '19 at 18:02
  • @user3314418 You should mark as solved for that answer which actually solves your question. This answer didn't the following answer has the same advice as the solving comment. Other people will be mislead otherwise. Thanks. – Carolus Aug 24 '19 at 10:20
3

All you have to do is freeze the column headers, not rename them

Go to View > Freeze > Row 1 (or click on which ever row your header is on and choose Freeze Up to Row XX)

| improve this answer | |
-1

Is your sheet 'protected'and are you permitted to edit? Click>Tools>protect sheet a list of authorized users will appear! Make sure you are able to edit? If you are all you need do is click on the collum heading and type in your edit?

| improve this answer | |
  • Have you tried this? Doing so edits the first cell in the column, not its heading – Ben Leggiero Jun 28 '19 at 18:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.