Excel shows columns as letters by default, but you can change them to numbers

Excel normally labels columns as A, B, C, and so on across the top. If your spreadsheet is showing columns as 1, 2, 3 instead, you are in R1C1 reference style mode. Switching back to the standard letter format takes one step in the Options menu. If you want to go the opposite direction — from letters to numbers — that is the same setting, just toggled the other way.

The change affects how your entire spreadsheet displays columns, not just one sheet. Once you flip the setting, all open workbooks and future workbooks will use the same format unless you change it again.

Key Takeaways

  • Column numbers (1, 2, 3) appear when R1C1 reference style is turned on; letters (A, B, C) are the standard format.
  • You reach the setting through File > Options > Formulas, then check or uncheck "R1C1 reference style" depending on which format you want.
  • The change applies to all workbooks you open after you make it, not just the current one.
  • Formulas written in R1C1 style look different (like =SUM(R1C1:R10C5)) but work the same way as letter-based formulas.

Steps to change from numbers back to letters

Open Excel and go to the File menu in the top left. Click File, then select Options at the bottom of the menu. A window titled "Excel Options" will open.

On the left side of the Options window, click Formulas. In the main panel, look for a checkbox labeled "R1C1 reference style" under the Working with formulas section. If the box is checked, click it to uncheck it. If it is already unchecked, your columns should already be showing as letters — check your spreadsheet to confirm. Click OK at the bottom right to save the change.

Your columns will now display as A, B, C, D, and so on. If you had any formulas written in R1C1 style (like =SUM(R1C1:R10C5)), they will automatically convert to the letter format (like =SUM(A1:E10)).

Steps to change from letters to numbers

If you want the opposite — to see columns labeled 1, 2, 3 — follow the same path: File > Options > Formulas. This time, check the box next to "R1C1 reference style" if it is unchecked. Click OK.

Your columns will now show as numbers instead of letters. This format is less common in everyday spreadsheet work, but some people find it clearer when working with large datasets or writing formulas that reference rows and columns by position rather than by name.

Why Excel has two column labeling systems

The letter system (A, B, C) is called A1 reference style and is the standard in modern Excel. The number system (1, 2, 3) is called R1C1 reference style, where R stands for row and C stands for column. R1C1 was the default in older spreadsheet programs and is still used in some industries and in Excel macros.

When you write a formula in R1C1 style, it reads differently. Instead of =SUM(A1:A10), you would write =SUM(R1C1:R10C1), meaning "sum from row 1 column 1 to row 10 column 1." Both formulas do the same thing — the style is just a different way of naming the cells.

What happens to your formulas when you switch

If you switch from R1C1 back to A1 style, Excel converts all your existing formulas automatically. A formula that read =SUM(R1C1:R10C5) will become =SUM(A1:E10). You do not have to rewrite anything.

The same works in reverse. If you switch from A1 to R1C1 style, formulas like =SUM(A1:E10) will convert to =SUM(R1C1:R10C5). The underlying calculation stays the same — only the way it is written changes.

The setting does not stick to one file

The R1C1 setting is not saved per spreadsheet. It is a program-wide setting in Excel itself. If you turn on R1C1 reference style, every workbook you open will show numbered columns until you turn the setting off again.

This matters if you work with other people. If a colleague sends you a spreadsheet and you see numbered columns, it is because your Excel is set to R1C1 style — not because the file itself is different. Changing the setting on your computer will not affect how the file looks on theirs.

Frequently Asked Questions

Why did my columns suddenly change to numbers?

Someone or something turned on R1C1 reference style in your Excel settings. This might have happened if you installed a macro, opened a file from someone using that style, or accidentally toggled the setting. Go to File > Options > Formulas and uncheck "R1C1 reference style" to switch back to letters.

Will changing the column format break my formulas?

No. Excel converts all formulas automatically when you switch between A1 and R1C1 style. The formulas will work exactly the same way — only the way they are written on screen will change.

Can I use both letter and number columns in the same spreadsheet?

No. The column labeling style is a program-wide setting, not something you can mix within one file. All columns in all open workbooks will use the same format.

Does R1C1 style make formulas easier to understand?

Some people find it clearer because it explicitly names rows and columns by position. Others find the letter system more intuitive. It is mostly a matter of what you are used to. Most everyday Excel users stick with the letter format.