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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

List all tables, including document structure 0
Help with column accumulation needed 2
Consistent Sheet column header rows 2
Countdown macro - display settings 2
Help with multi-level list 0
Changing login email address for office 365 admin (O365 Busines) 0
Formating bolded text exclusively. 0
Help with cell referencing. 0

Top