Column reference got changed

W

willy

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
 
V

VoG

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
Click to expand...

Tools | Options, General tab. Untick R1C1 reference style.
 
B

Bill Ridgeway

Goto <Tools><Options><Settings> and untick <R1C1 reference style>.

Regards.

Bill Ridgeway
Computer Solutions
 
Top