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.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×