Your column headings read 1, 2, 3 instead of A, B, C, and =A2*B2 now looks like =RC[-2]*RC[-1]. Nothing is broken: Excel’s R1C1 reference style option is on. In Excel for Windows, go to File > Options > Formulas, clear R1C1 reference style and select OK. The letters come back right away.
Applies to: Excel for Microsoft 365, Excel 2024, 2021 and 2016 on Windows, plus Excel for Mac. Excel for the web is covered separately below.
Turn off R1C1 to get column letters back
The setting lives in a different place on each platform, so follow only the steps for the version you have open.
Excel for Windows
- Select the File tab, then Options at the bottom of the left pane. If Options is not listed (for example in a narrow window), it may be under More.
- In the Excel Options window, select Formulas in the left list.
- Under Working with formulas, clear the R1C1 reference style check box.
- Select OK. The column headings change to letters and every formula in open workbooks is shown in A1 form again.
If you prefer the keyboard, press Alt+F to open the File tab, then select Options.
Excel for Mac
- With a workbook open, select the Excel menu in the menu bar and choose Preferences. If you don’t see Preferences, look for Settings in the same menu.
- Under Formulas and Lists, select Calculation.
- Clear Use R1C1 reference style, then close the window. The headings switch back to letters.
Excel for the web
Excel for the web does not appear to offer an R1C1 reference style option, so there is nothing to switch off in the browser. If a file shows numbered headings or R1C1 formulas there, open it in the desktop app (select Open in Desktop) and change the option on Windows or Mac.
Optional: switch it with one line of VBA
If you flip between styles often, a tiny macro saves the trip through Options. Excel’s Application.ReferenceStyle property controls both the headings and how references are shown, and it accepts xlA1 or xlR1C1. A macro containing Application.ReferenceStyle = xlA1 puts the letters back. Store it in your Personal Macro Workbook if you want it available everywhere, and see running a macro from the Developer tab or a shortcut if you have not run one before.
What R1C1 means and how your formulas look now
Excel’s default is the A1 style: a letter for the column (A through XFD, which is 16,384 columns) and a number for the row (up to 1,048,576). R1C1 style numbers both. R stands for row and C for column, so R3C2 is row 3, column 2, the same cell A1 style calls B3.
Relative references are written as offsets in square brackets, counted from the cell that holds the formula. Positive numbers mean down or right, negative numbers mean up or left, and a missing number means the same row or column. Here is how a few common formulas read in each style when the formula sits in cell C5:
| What the formula does | A1 style | R1C1 style |
|---|---|---|
| Multiply the two cells to the left | =A5*B5 | =RC[-2]*RC[-1] |
| Use the cell two rows up, same column | =C3 | =R[-2]C |
| Point to a fixed cell (absolute) | =$A$1 | =R1C1 |
| Total the four cells above in column C | =SUM(C1:C4) | =SUM(R[-4]C:R[-1]C) |
Notice that absolute references such as $A$1 become plain row and column numbers with no brackets. If the dollar-sign form is new to you, how absolute cell references work explains the A1 side.
Switching styles changes how Excel displays references, not what they point to. A formula keeps the same cells and returns the same result in either style, and Excel rewrites the display for you when you change the option. You do not need to retype anything after switching back.
Why Excel switched to numbers
Most people never touch this check box on purpose, so the change usually has one of these causes:
- A workbook from someone who uses R1C1. The option is an Excel setting rather than a formatting choice in one sheet, but a workbook saved while R1C1 was on can switch Excel to R1C1 when it is the first file you open in a session. Microsoft’s pages do not describe this, so treat it as a likely explanation rather than a guarantee.
- A macro or add-in. Code can set
Application.ReferenceStyletoxlR1C1and never set it back. The macro recorder also writes formulas in R1C1 form (you will seeFormulaR1C1in recorded code), which is normal and does not by itself change your headings. If you build macros, recording a macro in Excel shows where that code ends up. - A stray click in Excel Options. The check box sits near other formula settings people change for calculation or error checking.
Here is a typical case. Priya receives a budget workbook from a colleague, double-clicks it with Excel closed, and every workbook she opens afterward shows numbered columns. She clears the option once, closes Excel, and next time opens one of her own files first. If the numbers return only when the colleague’s file opens first, the file is the trigger: open it after another workbook, or ask the colleague to save a copy with R1C1 turned off.
When R1C1 is actually useful
R1C1 is not a mistake setting. Microsoft notes it is handy for working out row and column positions in macros, because code can build a reference like R2C5 from two numbers without converting 5 to a letter. Two other everyday uses:
- Counting columns for lookups. Functions such as VLOOKUP and INDEX ask for a column number. Turning R1C1 on for a moment shows that column AF is 32 without counting on your fingers.
- Spotting a broken copied formula. A formula filled down a column reads exactly the same in every row in R1C1, for example
=RC[-2]*RC[-1]. One cell that reads differently is the one that was overwritten or pasted wrong. Jordan uses this to audit a 500-row price list in seconds, then switches back to A1.
Questions people ask after switching back
Do I have to change it in every workbook?
No. It is an application option, so clearing it once affects all workbooks you open in that copy of Excel. If it keeps returning, look for the trigger file or macro described above.
I want numbers in a column, not in the headings. Is that this setting?
No. R1C1 only changes the gray headings and the reference notation. To put 1, 2, 3 in cells down a column, use Fill or a formula, as shown in numbering a column in Excel.
The headings are letters, but they disappeared entirely. Same problem?
No. Missing headings are a display setting. Go to File > Options > Advanced, scroll to the display options for the worksheet and select Show row and column headers.
Will other people see numbered columns when I send the file?
Their own Excel setting decides what they see, although a file saved in R1C1 mode can switch their Excel if it is the first workbook they open. Saving after you turn R1C1 off avoids passing the problem on.
Once the letters are back, Microsoft’s overview of formulas in Excel is a good refresher on A1 references, ranges and the reference styles side by side.
Matt Jacobs writes and maintains the guides on Support Your Tech, which he started in 2017. He spent most of his career keeping small-business PCs running and still takes the occasional consulting job, so the steps here come from fixing the same problems on other people’s computers. Every guide is checked on his own Windows 11, Windows 10, Mac, iPhone and iPad before it goes up.