Cell names have changed

Copper Contributor

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

3 Replies

@Annette1845 

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

Hello, the same happened to me on the Mac the I don't have any box "Use R1C1 reference style"@HansVogelaar 

@JosONLINK 

How about Excel menu > Preferences > Calculation > Use R1C1 reference style.