Site icon Professor Excel

Column Headings: Column numbers instead of letters?

When you usually open Microsoft Excel and create a new workbook, you would see your well-known worksheet style: Row numbers on the left and column letters on the top of the cells. But sometimes, you would see something different: Column number instead of letters. What has happend? And how can you change it back?

This article is part of our big Excel FAQ.

Learn about all the most frequently asked questions. Or ask a questions yourself!

In a hurry? In Excel, go to File –> Options –> Formulas (on the left) and remove the check from “R1C1 reference style“.

What are column numbers in Excel?

Excel provides the option to switch from letters (=default) to numbers in the headings. If you use numbers in the headings, it’s called the “R1C1 reference style” or “Relative Notation”. It’s an older style of referencing cells.

The R1C1 reference style: Column letters instead of numbers.

The problem with it: Formulas look much different if you use column letters.

In some cases it could make sense to use numbers instead of letters:

Formulas and functions look very different in the R1C1 reference style

However, in most cases you want to use column letters (this is called the “A1-Notation” style)

How to switch back column headings to letters (A, B, C)

So, how to switch from column numbers to letters?

Switch column headings from numbers to letters within the Excel options.
  1. Go To File and click on Options.
  2. Select Formulas on the left hand side.
  3. Set the tick at “R1C1 reference style”.

Switching back from numbers to letters works the same way. Only in the last step, you have to remove the tick from “R1C1 reference style”.

Do you want to boost your productivity in Excel?

Get the Professor Excel ribbon!

Add more than 120 great features to Excel!

Image by Free-Photos from Pixabay

Exit mobile version