Forum Discussion

TR9Casten

Copper Contributor

Feb 25, 2023

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

office 365

HansVogelaar

MVP

Feb 25, 2023

TR9Casten

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'.

plghys40

Copper Contributor

Oct 02, 2024

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, Peter

HansVogelaar
MVP
Oct 02, 2024
plghys40

Does 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.
- plghys40
  Copper Contributor
  Oct 02, 2024
  HansVogelaar Thanks for the quick response.
  Easiest to show you. You can see the column headings.
  Regards, Peter
  - HansVogelaar
    MVP
    Oct 02, 2024
    plghys40
    
    It does look like the active cell is in a table