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'.
- 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.
HansVogelaar Thanks for the quick response.
Easiest to show you. You can see the column headings.
Regards, Peter
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
