Excel Columns Showing Numbers Instead of Letters (R1C1)

When Excel columns are showing numbers instead of letters (1, 2, 3 across the top instead of A, B, C), a setting called R1C1 reference style is turned on. It's a display option, not an error: your data and formulas are safe, and you can switch back to letters in a few clicks. This guide shows how on Windows and Mac, what the R1C1 references mean while you're there, and why the setting sometimes comes back.

Why Excel columns show numbers instead of letters#

Excel has two ways to name cells. The usual one, A1 style, uses a letter for the column and a number for the row, so the cell in column D, row 3 is D3. The other, R1C1 style, numbers both: that same cell is R3C4, row 3, column 4.

When R1C1 style is on, three things change at once:

• The column headings show 1, 2, 3 instead of A, B, C.
• The Name Box shows addresses like R3C4 instead of D3.
• Formulas show references like =SUM(R2C2:R5C2) or =R[-1]C*2 instead of =SUM(B2:B5).

The workbook behaves exactly the same. Only the labels change. If the grid itself looks unfamiliar, the cells, rows and columns lesson explains how A1 addresses work.

How to switch back to letters on Windows#

Turn off R1C1 in Excel's Options:

1. Click File > Options. (In Excel 2007, click the Office button, then Excel Options.)
2. Choose Formulas on the left.
3. Under Working with formulas, clear the R1C1 reference style box.
4. Click OK.

The columns go back to A, B, C straight away, and every formula switches to A1 style. Nothing needs to be retyped, and the change applies to every workbook you have open. Save the file afterwards so it remembers A1 style next time.

How to switch back on a Mac#

On a Mac, the setting lives in the preferences:

1. Open the Excel menu and choose Preferences (called Settings in some newer versions).
2. Click General.
3. Clear Use R1C1 reference style.
4. Close the window.

If the box is already clear but a file still shows numbers, close and reopen the workbook, or check the next sections: the setting is saved with each file.

What R1C1 references mean#

R1C1 references are easy to read once you know two rules. Numbers without brackets are fixed positions, like $ references in A1 style. Numbers in square brackets are offsets from the cell that holds the formula: positive is down or right, negative is up or left.

Here is how the same references look in both styles, for a formula in C3:

So R[-1]C is "the cell just above", wherever the formula is. A blank bracket part (just R or C) means "same row" or "same column". This is the same idea as relative and absolute references, written differently; see relative vs absolute references and mixed references for the A1 side, and practise absolute references with the $ sign until it's automatic.

To translate a column number into a letter, =CHAR(64+4) returns "D", because character 65 is A. That works for columns 1 to 26 only. For any column, use =SUBSTITUTE(ADDRESS(1,28,4),"1",""), which returns "AB" for column 28.

Why R1C1 keeps coming back#

R1C1 style is saved with the workbook. When you open a file that someone saved in R1C1 style, Excel can switch to R1C1 for the session, and other files then show numbered columns too. The usual causes are:

• A file from a colleague who works in R1C1 style.
• A file exported by another program that saves in R1C1 style.
• A macro that sets the reference style and doesn't set it back.

The fix is the same each time: turn the option off, then save the file so it stores A1 style. If it keeps happening with one workbook, open that file first, turn off R1C1 and save it.

When R1C1 is actually useful#

R1C1 isn't just a nuisance. It shows when a column of formulas is consistent. In A1 style, the formulas in C2, C3 and C4 read =B2*2, =B3*2 and =B4*2, which all look different. In R1C1 style they are all =RC[-1]*2, so one formula that differs stands out immediately.

It also appears in a few places even when the option is off:

• INDIRECT can read R1C1 text if you set its second argument to FALSE: =INDIRECT("R2C3",FALSE) returns the value in C2.
• Macros often write formulas in R1C1 style because the same text works in every row.

For checking addresses and jumping to cells, the Name Box tips work in both styles. If your problem is that formulas show as text rather than results, that's a different setting; see why a formula shows as text, and the guide to cell references explained covers the A1 basics.

Practise it#

Once your columns show letters again, make sure references feel natural. Practise cells, rows and columns in a live spreadsheet: you click and type, and each step is checked instantly. Then try the exercise on this page and turn R3C4 into its A1 address.