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

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
 
N

Norman Harker

Hi! G!

Use:

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

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top