Today we’ll talk about how to change numbers to letters in Excel. In some cases this is necessary. However, many users of the Excel editor are used to the fact that line numbers are indicated by numbers; in turn, columns can be identified by letters.
Instruction manual
In order to solve the question of how to change numbers into letters in Excel, first of all we make some changes to the link style. To do this, go to the table editor settings. As a result, the numbers in the columns will be replaced by letter symbols. Note that the value of the described setting is saved in a file with the table, thus, opening the material, in the future we will load the specified parameter. Excel instantly recognizes previous edits and adjusts the column numbering according to user requirements. If you open a file that has a different meaning for this setting, we will see a different style in the column numbering. In other words, if you come across a table with unusual settings, in all other materials they will remain the same.
Excel Options
We move on to the next step in resolving the issue of how to change numbers to letters in Excel, and open the editor’s main menu by clicking on the large round button in the upper left corner of the window. Below, we will see two functions. One of them is called Excel Options. Click on it. The described actions can be performed without the use of the mouse - the main menu is opened by first pressing the ALT key, and then "". In turn, the letter “M” will allow you to open access to the Excel parameters we need.
Link Style
In order to solve the question of how to change numbers to letters in Excel, select the "Formulas" item. It is located on the left in the settings window that opens. We find the parameter that is responsible for working with formulas. It is the first paragraph in the indicated section, marked as “Link Style”, that determines how columns will be designated on all pages of the editor. In order to replace numbers with letters, we remove the corresponding mark from the described field. This type of manipulation can be performed using both the mouse and keyboard. In the latter case, use the keyboard shortcuts ALT + 1. After all the actions done, click the "OK" button. Thus, the changes made to the settings will be recorded. In earlier versions of this software, the access button to the main menu has a different appearance. If the edition of the editor “2003” is used, we use the “Parameters” section in the menu. Next, go to the “General” tab and change the “R1C1” setting. So we figured out how to change numbers to letters in Excel.