alter column ref

[Kaz]

my column references are displayed in numeric rather than alphabetic. eg. the
first column is 1, instead of A. Can anyway help me? thanks Kaz

 

[Ms-Exl-Learner]

Excel 2003:-
Tools>>Options>>General>>Settings>>Uncheck the R1C1 reference style and give
ok.

Excel 2007:-
Press Alt+T+O>>Formulas>>Working with formulas>> Uncheck the R1C1 reference
style and give ok.

Remember to Click Yes, if this post helps!

 

[ozgrid.com]

Go into Excel Options and uncheck R1C1 Reference Style.

 

[T. Valko]

In Excel 2007:

Office button>Excel Options>Formulas>Working with formulas>uncheck R1C1
reference style>OK out

Other versions of Excel:

Tools>Options>General tab>Settings>uncheck R1C1 reference style>OK out