Changing column headers from alphabetical characters to numbers?

[dylan]

I have inherited a spreadsheet that uses column headings in numbers as well
as the rows. How can I reinstate the column headings to alphabetical
characters?

 

[Mike H]

Try,

Tools|Options|General
Un-Check R1C1

Mike

 

[Gord Dibben]

Tools>Options>General Uncheck "R1C1 reference style"


Gord Dibben MS Excel MVP