Column Labels switched from letters to numbers

  • Thread starter Thread starter Melanie
  • Start date Start date
M

Melanie

I opened a spreadsheet from another user. It
automatically converted my column labels (A,B,C...) to
numbers. When I click on a cell the reference is now R1C1
etc. I would like to change them back to letters, but can
not find where to do this. I have tried completely
shutting down excel and then opening again but these
setting seem to remain. How can I fex this?
 
Tools|Options|General Tab
Uncheck the R1C1 reference style checkbox.

And save your workbook.

Excel picks this setting up from the first workbook you open in that session.
(If you have others saved as R1C1 style and open them first, you'll have to do
it again. So it's a good one to remember.)
 
Back
Top