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

Cumulative formula for word table 0
Setting column width in a table with a macro is not working 0
Embedded Excel into Word with Tables 0
Working outlook via vba code with xlsx - error 0
Problem with SET & REF function 0
How to rename the head A,B,C,D,E etc. on every column 0
Dealing with the error: unable to filter on excel hc home school 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0

Top