J Julio Oct 8, 2008 #1 in excel 2007 my column and row references are all numbers all of a sudden. How can I get the column references back to letters?
in excel 2007 my column and row references are all numbers all of a sudden. How can I get the column references back to letters?
S Sheeloo Oct 8, 2008 #2 To turn R1C1 referencing on or off in Excel 2007: 1. Click the Office Button. 2. Click Excel Options. 3. Switch to the Formulas tab. 4. Click the R1C1 reference style check box. A filled box will enable R1C1, a cleared box will disable it. 5. Click OK.
To turn R1C1 referencing on or off in Excel 2007: 1. Click the Office Button. 2. Click Excel Options. 3. Switch to the Formulas tab. 4. Click the R1C1 reference style check box. A filled box will enable R1C1, a cleared box will disable it. 5. Click OK.
