In Excel, columns have letters as their identity, but you can change them to numbers. That means for column A you can use column 1. In this tutorial, we will learn two different ways that you can use.
- Create Header Row with Column Number
- Change Cell Reference to R1C1 to Apply for Column Numbers

Change Column Alphabets to Number (R1C1)
- First, click on the File Tab.

- After that, go to “Options”.

- Next, click on “Formulas” and from there, tick the “R1C1 reference style” checkbox (under Working with formulas).

- In the end, click OK to apply the settings.

When you do this, it changes the reference style for all the open workbooks, and Excel saves the setting with the file. That means now you need to refer to a column using a number, not a letter.

You see in the above example where I am referring to cell A1 it shows R[-1]C[-2] instead of the A1. Well, this means you are referring to the cell one row up and two columns to the left of the formula cell.
You can learn more about it from this complete guide on the R1C1 reference style.
Create a Header with Column Numbers
This method can be used in different situations, and it’s just as effective as the first one. It doesn’t change the column letters; it adds a row with the column numbers.
- First, edit cell A1 and enter “=COLUMN()” in it.

- After that, hit enter to get the number of the current column.

- Now, use the fill handle and extend the formula to the right, up to the last column where you want column numbers.

- In the end, you can convert all these formulas into values by using the keyboard shortcut (Ctrl + C to copy and then press Alt → H → V → V to paste the values).
This method works better when you don’t want to change the cell reference style but only want the column numbers.
Get the Column Number from a Column Letter
If you have a column letter in a cell (like “D” in A1) and want its number, combine COLUMN with INDIRECT. It returns 4 for D and 28 for AB:
=COLUMN(INDIRECT(A1&"1"))
And to go the other way, from a column number to its letter, use ADDRESS with 4 (relative reference) and remove the row number. This formula returns “D” for 4:
=SUBSTITUTE(ADDRESS(1,4,4),"1","")
To count how many columns a range has, use the COLUMNS function with that range; for B2:F2, it returns 5.
Turn on R1C1 on a Mac
On a Mac, go to Excel ➜ Preferences (Settings in newer versions) ➜ Calculation, and tick “Use R1C1 reference style”.
Frequently Asked Questions
How do I change the column numbers back to letters?
Go to File ➜ Options ➜ Formulas and untick “R1C1 reference style”. If the columns show numbers every time you open a particular file, that file was saved in R1C1 style, so change the setting and save it again.
Does R1C1 change my formulas?
No. It only changes how Excel shows the references. A formula that adds A1 and B1 is shown in R1C1 style, and it goes back to A1 style when you turn the setting off; the results stay the same.
What is the last column number in Excel?
A worksheet has 16,384 columns, so the last one is column 16384, which is XFD in letters.