Excel is showing numbers for column headers instead of the familiar A, B, C letters. This happens because the R1C1 reference style has been enabled. R1C1 mode uses row and column numbers for cell references. This article explains how to switch back to the standard A1 reference style.
Key Takeaways: Restoring Standard Column Letters
- File > Options > Formulas > Uncheck R1C1 reference style: This is the primary setting to restore column letters in the main Excel window.
- Alt + F, T, F, Alt + R, Enter: The keyboard shortcut sequence to quickly navigate to and toggle the R1C1 setting.
- Check the setting in new workbooks: The R1C1 mode is saved per-user, so disabling it applies to all future files you create.
What is R1C1 Reference Style?
Excel has two primary systems for identifying cells: A1 and R1C1. The A1 style is the default. In this system, columns are labeled with letters and rows with numbers. A cell reference like C5 means column C, row 5.
The R1C1 style uses numbers for both rows and columns. “R” stands for Row and “C” for Column. In this mode, the cell reference R5C3 means row 5, column 3. Column 3 corresponds to column C in the A1 system. This mode is sometimes used in programming or advanced formula writing because it makes relative references easier to calculate.
The setting is stored in your Excel application preferences, not within the workbook file itself. When enabled, it affects how you see column headers and how you write formulas. Disabling it will immediately revert your view to the standard lettered columns.
Steps to Disable R1C1 Reference Style
Follow these steps to turn off R1C1 mode and restore column letters. You only need to do this once for your user profile.
- Open the Excel Options dialog
Click the File tab in the top-left corner of the Excel window. Then select Options from the bottom of the menu. - Navigate to the Formulas settings
In the Excel Options window, click the Formulas category from the left-hand sidebar. - Locate the Working with formulas section
Scroll down within the Formulas settings until you see the heading “Working with formulas”. - Uncheck the R1C1 reference style box
Find the checkbox labeled “R1C1 reference style”. Click on it to remove the checkmark. - Apply the change
Click the OK button at the bottom of the Excel Options window. Excel will apply the change immediately.
Using the Keyboard Shortcut
You can also use keyboard shortcuts to complete this action faster.
- Open the Backstage view
Press Alt + F to open the File menu. - Open Excel Options
Press the T key to select the Options button. - Go to the Formulas section
Press the F key to jump directly to the Formulas category. - Toggle the R1C1 setting
Press Alt + R. This will select or clear the “R1C1 reference style” checkbox. If it is checked, pressing Alt + R will uncheck it. - Confirm and exit
Press the Enter key to close the Options window and save the change.
If Column Numbers Persist or Formulas Break
Excel Still Shows Numbers After Disabling the Setting
Close and restart Excel completely. The setting change may not refresh the current workbook window until the application is restarted. If the problem continues, check if the setting was saved correctly by reopening File > Options > Formulas.
Existing Formulas Now Show Errors
Formulas written while R1C1 was active use a different syntax. For example, you might see =R[-1]C instead of =A1. Excel will not automatically convert these. You must manually re-enter the formulas using standard A1 references after disabling R1C1 mode.
A Specific Workbook Always Opens with Column Numbers
A workbook file itself cannot force R1C1 mode. However, if you open a workbook that was last saved by someone else with R1C1 enabled on their computer, your Excel will display it with column numbers if your own R1C1 setting is still on. Ensure your global setting is turned off as described above.
A1 Reference Style vs. R1C1 Reference Style
| Item | A1 Reference Style (Default) | R1C1 Reference Style |
|---|---|---|
| Column Headers | Letters (A, B, C) | Numbers (1, 2, 3) |
| Cell Reference Example | B10 | R10C2 |
| Relative Reference Syntax | B10 (static) | R[10]C[2] (brackets indicate offset) |
| Primary Use Case | General spreadsheet use | Macro recording, advanced formula logic |
| Setting Location | File > Options > Formulas | File > Options > Formulas |
You have successfully restored the standard column letters in Excel by disabling R1C1 reference style. Your column headers will now display as A, B, C. Remember that this is a user-level setting, so it will apply to all new workbooks you create. If you work with macros, you may encounter R1C1 syntax in VBA code, but the interface will remain in A1 style. For another display tweak, you can explore customizing the Quick Access Toolbar via File > Options > Quick Access Toolbar.