Forum Discussion

Copper Contributor

Apr 30, 2021

Cell names have changed

The cell names are all numeric instead of being alpha for the columns, how can I change back

MVP

Apr 30, 2021

Excel for Windows:

Select File > Options > Formulas.
Clear the check box 'R1C1 reference style' and click OK.

Excel for Mac:

Select Excel menu > Preferences > General.
Clear the check box 'Use R1C1 reference style'.

JosONLINK
Copper Contributor
Nov 23, 2023
Hello, the same happened to me on the Mac the I don't have any box "Use R1C1 reference style"HansVogelaar
- HansVogelaar
  MVP
  Nov 23, 2023
  JosONLINK
  
  How about Excel menu > Preferences > Calculation > Use R1C1 reference style.

Resources