Columns headed by numbers

[Carl Clements]

Hi,

Currently my Excel 2000 worksheets have numbers rather than letters as the column headers. How do I change this to letters?

eg instead of cell A1 it is cell 11

 

[Jon von der Heyden]

Hi

Welcome to the board!

Go to Tools -> Options -> General (tab) and uncheck "R1C1 reference style"

HTH
Jon

 

[arthurbr]

Hi and welcome to the board
Tools - Options - general tab - Uncheck "R1C1 reference style"

Cheers

 

[Carl Clements]

thanks