Column reference got changed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Column references in my excel sheets which which usually show as A B C D
....... are now showing 1 2 3 4 5
Please help
 
willy said:
Column references in my excel sheets which which usually show as A B C D
...... are now showing 1 2 3 4 5
Please help

Tools | Options, General tab. Untick R1C1 reference style.
 
Goto <Tools><Options><Settings> and untick <R1C1 reference style>.

Regards.

Bill Ridgeway
Computer Solutions
 
Back
Top