Office Settings & Configuration

Change Excel References from R1C1 to A1 Style

Jason MillerJason Miller Nov 18, 2026 868 views

Question details

The user wants to change Excel cell references from R1C1 style back to A1 style.

Change Excel References from R1C1 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.
Before you start

Open Excel and check whether your worksheet columns are labeled with numbers rather than letters. Follow the instructions for your operating system.

Solution 1Recommended

Turn off R1C1 reference style in Excel for Windows

Use Excel Options to restore column letters and A1-style formulas on Windows.

1
Open Excel Options

In Excel, select File > Options.

2
Change the reference style

Select Formulas, then clear the R1C1 reference style checkbox.

3
Apply the setting

Select OK and return to the worksheet. Column headings should display letters.

Turn off R1C1 reference style in Excel for Windows
Free Microsoft Office alternative

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.

Work with familiar A1 cell references in spreadsheetsOpen and edit Microsoft Excel XLS and XLSX filesNavigate a familiar, easy-to-use interfaceMove existing Office files into a lightweight, free suite
microsoft office alternative - wps office

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.