Columns

%3CLINGO-SUB%20id%3D%22lingo-sub-648794%22%20slang%3D%22en-US%22%3EColumns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-648794%22%20slang%3D%22en-US%22%3E%3CP%3EWhy%20are%20my%20columns%20labeled%20with%20numbers%20instead%20of%20letters%3F%26nbsp%3B%20How%20do%20I%20change%20them%20back%20to%20letters%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-648794%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-648801%22%20slang%3D%22en-US%22%3ERe%3A%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-648801%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGo%20to%20Excel%20%3CSTRONG%3EOptions%20%26gt%3B%26gt%3B%20Formulas%3C%2FSTRONG%3E%20and%20uncheck%20the%20below%20option%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116115i810A574F1C1E2001%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22R1C1%20reference%20style.png%22%20title%3D%22R1C1%20reference%20style.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F349095%22%20target%3D%22_blank%22%3E%40DorieLee%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-648826%22%20slang%3D%22en-US%22%3ERE%3A%20Columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-648826%22%20slang%3D%22en-US%22%3EThanks%20so%20much%20for%20your%20prompt%20reply.%20I%20had%20looked%20on%20the%20%22Info%20page%22%2C%20but%20missed%20the%20%22Options%22%20down%20at%20the%20bottom.%20Again%2C%20thanks%3C%2FLINGO-BODY%3E
DorieLee
New Contributor

Why are my columns labeled with numbers instead of letters?  How do I change them back to letters?

 

2 Replies

Hi,

 

Go to Excel Options >> Formulas and uncheck the below option:

R1C1 reference style.png

 

 

Hope that helps

 

@DorieLee 

Thanks so much for your prompt reply. I had looked on the "Info page", but missed the "Options" down at the bottom. Again, thanks
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
Change default views for subfolders
mlilindstrom in SharePoint on
2 Replies