Office Settings & Configuration

Excel for Mac: Change Column Numbers Back to Letters

Khadija KhanKhadija Khan Nov 18, 2026 868 views

Question details

The user wants Excel to display column letters instead of numbers.

Change Column Numbers Back to Letters in Excel for Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
Working in a spreadsheet where R1C1 references make columns appear as numbers and may cause confusion when using formulas or AutoSum.
Observed behavior
Column headings display numbers rather than letters, and an AutoSum formula may also show a #SPILL! error.
Before you start

Open Excel on your Mac and check whether both rows and columns are numbered. This usually indicates that R1C1 reference style is enabled.

Solution 1Recommended

Turn Off R1C1 Reference Style in Excel for Mac

Restore the standard A1 reference style, with letters for columns and numbers for rows.

1
Open Excel preferences

In the macOS menu bar, select Excel > Preferences. In some versions, the menu item is called Settings.

2
Open General settings

Select General in the Excel preferences or settings window.

3
Clear the R1C1 option

Clear the Use R1C1 reference style checkbox. Return to the worksheet and check that the columns are labeled A, B, C, and so on.

Turn Off R1C1 Reference Style in Excel for Mac
A #SPILL! error is separate: Changing the reference style does not necessarily fix an AutoSum #SPILL! error. Select the error cell and check whether other cells or merged cells are blocking the intended spill range.
Free Microsoft Office alternative

Work With Spreadsheet Files in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheet to move your work across with minimal disruption. WPS does not change Excel's reference-style setting.

Work with spreadsheet formulas and familiar cell referencesOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar interface for an easier transitionChoose a free, lightweight office suite
QA img-9

Frequently Asked Questions

Why are my Excel columns numbered instead of lettered?

R1C1 reference style is likely enabled. In Excel for Mac, go to Excel > Preferences or Settings > General and clear Use R1C1 reference style.

What is the difference between A1 and R1C1 references?

A1 style identifies a cell by its column letter and row number, such as B2. R1C1 style uses row and column numbers, such as R2C2.

Will turning off R1C1 fix my AutoSum #SPILL! error?

Not necessarily. Select the cell showing #SPILL! and check whether entries or merged cells are blocking the range where the formula needs to return results.

Can I turn R1C1 references back on later?

Yes. Go to Excel > Preferences or Settings > General and select Use R1C1 reference style again.