Applies ToExcel for Microsoft 365 for Mac Excel 2024 for Mac Excel 2021 for Mac

Cause: The default cell reference style (A1), which refers to columns as letters and refers to rows as numbers, was changed.

Solution:    Clear the R1C1 reference style selection in Excel preferences.

Difference between A1 and R1C1 reference styles

A1 and R1C1 cell reference styles

  1. On the Excel menu, select Preferences.

  2. Under Formulas and Lists, select Calculation Calculation2.

  3. Clear the Use R1C1 reference style check box.

    The column headings now show A, B, and C, instead of 1, 2, 3, and so on.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.