Forum Discussion
Columns
Hello, my Excel columns and rows are both numbered. How do I change the columns back to letters.
Thanks
2 Replies
Hi Brandon
In a more elaborate description to what Dan has correctly said, try this out:
1. Click onto the File tab.
2. Click onto Options.
3. Click onto Formulas.
4. Untick R1C1 reference style.
Hope that helps!
Cheers
Damien
In the 'Options' of Excel, you have set the formulas to use the R1C1 reference - disable that, and you get the column letters back.
