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

Showing Letters For Column Headers Rather Thann Numbers ? 1
Column headings changed from ABC to 123 format 2
How to change the column headers from ABC to 123 2
Hiding Header Columns abc... in 2007 1
Formula (or code) return the largest number of duplicates in a list. 16
Why are my excel columns labelled as numbers instead of ABC etc? 1
Columns now numbers rather than letters how do i get letters back 2
Excel 2007 change column labels from numbers to letters 8

Top