Column names are 1,2,3,....

  • Thread starter Thread starter G. Sawyer
  • Start date Start date
G

G. Sawyer

I just noticed today that the column names in my excel
spreadsheets are no longer alphabetical, but are
numerical. The column marked "1" is defined by excel as
column "1C", and row "1" is defined as row "1R".

How can I get the column names to change back to the
alphabet?

Thanks
 
Hi! G!

Use:

Tools > Options > General
Remove check from "R1C1 reference style"

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top