Column Name Box Question

  • Thread starter Thread starter Excel-lent
  • Start date Start date
E

Excel-lent

Guest
Hi all, this is my first post!

I've had a search but cannot find an answer to this question. Just recently my columns on all saved Excel files have changed from letters to numbers which has subsequently changed all formulas making it a bit more difficult to work with. (EG instead A1*B1 it now says RC[-2]*RC[-1])

Does anyone know how to change this back, I wasn't aware I had changed any specific option! Thanks in advance for any help.
 
Hi, Excel-lent,

go to Tools / Options General and uncheck R1C1 reference syle.

Ciao,
Holger
 

Users who are viewing this thread

Back
Top Bottom