Renaming columns

Occasional Visitor

Hey all- I'm using excel to organize a novel–which I highly recommend so far–and I want to rename my ABC headers to chapters, synopsis, that sort of thing. So far, none of the options I've found online have done the trick, and I'm suspicious I'm missing something simple. Any thoughts are appreciated. 


1 Reply

Hi @mumfordzisk


As far as I know there isn't a way to change the column A,B,C etc headers short of using R1C1 which turns the letters into numbers.


The best way you can do achieve what you are after is to use Row 1 as your headers and put the name of each column in A1, B1, C1, etc.


Best wishes with your spreadsheet!




Related Conversations
Last Value Column from Another Column in Same List
Yepitsme in SharePoint on
6 Replies
Add Column Using Count
Tim Hunter in SQL Server on
0 Replies
Taking values from certain rows based on data input
Drakerla in Excel on
5 Replies
O365 SharePoint List Column Names Corrupted
Lori Hanley in SharePoint on
6 Replies
reverse text to columns for .csv import
milly87 in Excel on
3 Replies
Recover Old Name of the Files
Asjad Khan in Microsoft Teams on
2 Replies