Excel 2007 column references

G

Ginnybug

My column titles are numbers not letters. With this new 2007 interface, I
can't find the Options site to change the reference from R1C1 to A1.
 
T

Teethless mama

click on Office Button > Excel Options > Formulas > uncheck R1C1 refernce
style > OK out
 

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 do I get Excel column headings to be letters not numbers? 3
how do i change the column headings from numbers to letters 2
Column headings display as a numbers 7
column headers changed from letters to numbers, how do I change ba 1
How do I change default cell referencing in excel from R1C1 to A1? 1
Column headers numbers instead of letters 2
Excel 2007 changed the column Letters into numbers 1
How do I change Excel columns from alphabetical to numeric? 6

Top