My column headings are labeled with numbers instead of letters

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, click Preferences.

  2. Under Authoring, click General  General Preferences button .

  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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!