Forum Discussion
Column labels became numbers instead of letters
I reinstalled office 365, and Excel now shows numbers for columns rather than letters. Is this optional? Tom
On Windows:
Select File > Options > Formulas.
Under 'Working with formulas', clear the check box 'R1C1 reference style'.
Click OK.
On Mac:
Select the Excel menu > Preferences > Calculation.
Clear the check box 'Use R1C1 reference style'.
Thank you. I now realize this option of R1C1 is helpful for macros that seek to use values that show up in say, every 12th column or every 8th row.
Tom