How to fix excel columns now in numbers rather than ABC etc?

D

Dave Peterson

In xl2003 menus:
Tools|Options|General Tab|
Uncheck the R1C1 Reference style checkbox.

Katie B wrote:
 
K

Katie B

Dave Peterson said:
In xl2003 menus:
Tools|Options|General Tab|
Uncheck the R1C1 Reference style checkbox.

Katie B wrote: Unfortunately now on newer version and can't seem to track down the same function! One of the joys of upgrading I suppose!
Click to expand...
 
K

Katie B

Dave Peterson said:
In xl2003 menus:
Tools|Options|General Tab|
Uncheck the R1C1 Reference style checkbox.

Katie B wrote: Thank you Dave. Prompted me to look at the excel options on my new version and have found the old function now. Many thanks, frustration now solved!
Click to expand...
 

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

How to rename the head A,B,C,D,E etc. on every column 0
what could cause numbers to appear as row names and column names 2
How do I change column headings fron numbers to letters in excell. 2
Excel 2007 change column labels from numbers to letters 8
my column headings are numbers instead of letters.how do i fix 0
columns and rows labeled the same (cell 1-1 vs a-1) how do I chang 6
Why the column code in my excel is 123... instead of ABC...? 0
Numbers instead of ABC? 3

Top