Change Excel References from R1C1 to A1 Style
Question details
The user wants to change Excel cell references from R1C1 style back to A1 style.

- Product
- Microsoft Excel
- Device & OS
- Windows and macOS
- Scenario
- Excel displays column numbers instead of letters, and the user wants to restore standard A1 references.
- Observed behavior
- Column headings appear as numbers because R1C1 reference style is enabled.
Open Excel and check whether your worksheet columns are labeled with numbers rather than letters. Follow the instructions for your operating system.
Turn off R1C1 reference style in Excel for Windows
Use Excel Options to restore column letters and A1-style formulas on Windows.
In Excel, select File > Options.
Select Formulas, then clear the R1C1 reference style checkbox.
Select OK and return to the worksheet. Column headings should display letters.

Turn off R1C1 reference style in Excel for Mac
Use Excel preferences to restore A1-style references on a Mac.
Work with A1 References in WPS Spreadsheet
WPS Office is a free, lightweight alternative for working with spreadsheets. Its familiar interface and Excel format compatibility make it easy to open existing workbooks and continue using A1 references.

Frequently Asked Questions
Why are my Excel columns numbered instead of lettered?
R1C1 reference style is enabled. In Excel for Windows, go to File > Options > Formulas and clear R1C1 reference style.
Where is the R1C1 setting in Excel for Mac?
Select Excel > Preferences > General, then clear Use R1C1 reference style.
Will changing the reference style delete my formulas?
No. Changing the reference style changes how cell references are displayed; it does not delete formulas or worksheet data.
What is the difference between A1 and R1C1 references?
A1 style identifies a cell using a column letter and row number, such as A1. R1C1 style uses row and column numbers, such as R1C1.




