By default, columns are referenced as letters in Excel. It doesn’t have to be that way though!
You can reference your columns by number rather than letter if you so choose. It’s called an R1C1 style reference and it is more complicated, but it does serve a purpose and has often been needed for complex array formulas within macros in Excel.
Follow the steps below to learn how to change your column headings to numbers:
- Click the File tab of your Ribbon and Options.
- Click on the Formulas tab.
- In the Working with Formulas section, select R1C1 reference style.
- Click OK and you are finished!