Changing the display form of column names in Excel from numeric to alphabetic
Imagine that you sat down to work at a computer other than yours and were forced to deal with an Excel program whose parameters do not match yours. Thus, you saw that the column names are presented in numeric form, not alphabetic. And if this presentation of names is not convenient for you, then now you will find out what needs to be done so that the columns are named using letters again.
So, we have this representation of the column names:
But we want it to look like this:
To do this, you will need to do some minor manipulations with Excel parameters:
- Click on the menu button and press Excel Options.
- In the left column, select a section Formulas.
- In the area on the right, find the section Working with formulas and uncheck the box R1C1 link style.
Ready. Apply the changes you made, after which you will see that the column names have changed to letters.