alter column ref

  • Thread starter Thread starter Kaz
  • Start date Start date
K

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
 
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!
 
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
 
Back
Top