This question already has an answer here:
- Changing the A B C … column labels 1 answer
I would like to change Google spreadsheet header labels. I would like to change A,B,C... to more detailed descriptions. How do I achieve this?
-2
marked as duplicate by ale, jonsca♦ May 11 '17 at 1:54
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
migrated from superuser.com May 10 '17 at 23:11
This question came from our site for computer enthusiasts and power users.
-
Those are not header labels. Those are the names of the columns. You can add your own text in Row A if you wish. – InterLinked May 10 '17 at 10:10
-
But how to add text instead of A? It is not editable in my spreadsheet – vico May 10 '17 at 11:20
-
Add it in Cell A1. The cells themselves are editable. You can then format it to look like a column header and to scroll. It's like calling Room A112 in an office the 'supply room'. You can add a name to a column yourself but you can't change the actual identify of the column. – InterLinked May 10 '17 at 14:40
1
You don't. This is not how spreadsheets operate. The best you can have is the top row containing column names. Then you can freeze it, filter it etc.
