Excel for Mac: Change Column Numbers Back to Letters
Question details
The user wants Excel to display column letters instead of numbers.

- 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.
Open Excel on your Mac and check whether both rows and columns are numbered. This usually indicates that R1C1 reference style is enabled.
Turn Off R1C1 Reference Style in Excel for Mac
Restore the standard A1 reference style, with letters for columns and numbers for rows.
In the macOS menu bar, select Excel > Preferences. In some versions, the menu item is called Settings.
Select General in the Excel preferences or settings window.
Clear the Use R1C1 reference style checkbox. Return to the worksheet and check that the columns are labeled A, B, C, and so on.

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.

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.




