Excel Columns Showing Numbers Instead of Letters: The Fix

Excel Showing Numbers Instead of Letters for Column Headings

If your Excel column headers have suddenly changed from the usual A, B, C letters to 1, 2, 3 numbers, and your formulas have switched to references like R1C1 instead of A1, you haven’t broken anything — Excel has simply been switched into R1C1 reference style. This is a display/formula-entry setting, not a corrupted file.

Fixing it

1. Click File > Options.
2. Select the Formulas category on the left.
3. Under “Working with formulas,” untick R1C1 reference style.
4. Click OK.

Your column headers will immediately return to letters, and any formulas you’ve already entered will be redisplayed in normal A1 notation — nothing is lost by toggling this setting either way, since it’s purely a display preference and doesn’t change how the underlying formula is stored.

What actually causes it

A few common triggers, in roughly the order they come up in practice:

• A VBA macro changed it deliberately or accidentally. Application.ReferenceStyle = xlR1C1 is a single line that some macros (especially older ones recorded years ago, or ones copied from forum answers) run and never set back. If R1C1 style keeps reappearing every time you open a specific workbook, check that workbook’s VBA project for this line, usually in a Workbook_Open event.
• The setting is per-installation, not per-workbook. R1C1 style is stored in your local Excel/Office settings, not in the file itself — so if a colleague sends you a workbook and their screenshots show R1C1 style, it’s their local setting, not something embedded in the file that will follow it to your machine.
• Habit carried over from another tool. R1C1-style references are the default in some other spreadsheet and scripting contexts, so users coming from those occasionally switch it on deliberately and then find Excel’s formula bar unfamiliar day-to-day.

When R1C1 style is actually useful

It’s not purely a nuisance setting — R1C1 notation is genuinely useful when you’re writing VBA that needs to refer to cells relative to the active cell (R[1]C[0] for “one row down, same column”, for example), since relative R1C1 references are far easier to reason about programmatically than working out what A1 becomes when copied three rows down. If you’re just entering formulas by hand day-to-day, though, A1 style is almost always the more readable choice, which is why it’s Excel’s default. You can browse our General Tech Accessories picks on Amazon. As an Amazon Associate, TechyGeeksHome earns from qualifying purchases.