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
- Hmm, I have turned off R1C1 reference style, and the Name box correctly shows references with letters for columns, but still the columns themselves are labelled Column1, Column2 etc... I just want to see A, B, C etc...
What do I need to do? It's only with one file...
Regards, PeterDoes that sheet contain a table? If you scroll a sheet with a table while the active cell is inside the table, the column letters A, B, C etc. will be replaced with the column headers of the table.
