When working with excel spreadsheets, there are times when we see that the column headers are named using numbers and not letters. This actually makes work easier in some cases but we can toggle it back. We can change the Column headings from numbers to letters.
Let us see how to do it.
R1C1 Reference Style
In Excel, we can get column headings named using numbers, not letters, as shown below.
This is known as the R1C1 Reference Style as both the rows and columns are labeled using numbers. This is commonly used in special cases.
- We want to use VBA and loops so as to reference these columns using variables in the loop. In this case, we are easier to work with columns named numbers. We would easily be able to refer to cells or ranges with the help of integer-type variables.
How We Can Change Columns Back to Alphabets?
In order to change the column headers back to alphabets, you need to follow the mentioned steps:-
- Open a New excel workbook. Go to File on the ribbon.
- Click on the Options Menu.
- This opens the excel options dialog box. Go to the Formulas tab.
- Go to the working with formulas section and unmark the R1C1 reference style.
This will change the column headings back to alphabets.
How to Remove Numbers as Column Headers in Excel 2007
In Excel 2007, the procedure to toggle the R1C1 style might not be the same but is easy just like in any other version of excel.
To remove numbers from the columns in excel, simply do the following procedure.
- Go to the Office button at the top.
- Go to Excel Options.
- Go to the Formulas tab. Uncheck the R1C1 reference style.
You can also learn about types of referencing in excel.
This brings us to an end. Thank you for reading.