ExcelBanter - Excel 2007 column references

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2007 column references (https://www.excelbanter.com/excel-discussion-misc-queries/201223-excel-2007-column-references.html)

Ginnybug

Excel 2007 column references

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.

Teethless mama

Excel 2007 column references

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

"Ginnybug" wrote:

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.

All times are GMT +1. The time now is 07:35 PM.