The title of this article may seem strange to some. In fact, everything is simple - for promotion, you need to use user queries in the search engine. Thus, people are more likely to find the answer to their question.
What is the crux of the problem?
Pay attention to the picture below:
Column names consist of numbers ... This happens when, without your knowledge, someone makes changes to the settings or a third-party program intervened and did something similar.
Of course, many have problems with this. People want return letters in the column names. In this article I will tell you how to fix numbers to letters in different versions of MS Excel .
Mircosoft Excel 2010 and older.
1. At the top left we are looking for the button " File ":
2. In the window that opens, select the item " Options ":
3. Go to the " Formulas ", in the work with formulas field, uncheck the box" R1C1 link style ":
Checking the result.
Mircosoft Excel 2007.
1. At the top left, click on the orange circle with the MS Office icon (number 1 in the figure below). In the window that opens, click on " Excel options "(number 2 in the figure below):
2. A window with settings has appeared. Click on the item " Formulas ", in the work with formulas field, uncheck the box" R1C1 link style ":
Mircosoft Excel 2003.
1. At the top we are looking for the button " Service ". Click on it. In the menu that opens, select the item" Options ":
2. Find the tab " Are common ". In the parameters, uncheck the box" R1C1 link style ":
We are happy!
I hope this article was useful to you! I try not to write too much to make it simple and understandable.
Thanks for attention!
Have a good mood!
Many users of the Excel program are accustomed to the fact that the names of the columns of the table are Latin letters. However, sometimes it can happen that numbers are displayed instead of letters, like line numbering.
This is possible for a number of reasons:
- software crashes;
- the user himself changed the corresponding setting, but did not notice how he did it or forgot.
- it is possible that another user working with the table made changes to the settings.
In fact, no matter what exactly the reason led to the change of designations, many users are in a hurry to put everything back in place, i.e. so that the columns are again denoted by the letters of the Latin alphabet. Let's see how to do it in Excel.
Changing Column Labels
In Excel, there are two methods, using which, you can return the horizontal coordinate pad to the look that most users of the program are used to. Let's take a look at both.
Method 1: setting program parameters
This method involves making changes to the program parameters. Here's what to do:
- Click on the menu "File" .
- In the window that opens, in the list on the left at the very bottom, click on the item "Options" .
- A window with program parameters will appear on the screen:
- switch to the "Formulas" section;
- on the right side of the window we find the settings block "Working with formulas" and uncheck the box next to the option "R1C1 Link Style" .
- push the button OK to confirm the changes.
- All is ready. Thanks to these rather simple and quick-acting actions, we returned the usual designations to the table.
Note: link style R1C1 - this is the parameter, the inclusion of which changes the Latin letters to numbers on the horizontal coordinate panel.
Method 2: Settings in Developer Mode
Before proceeding to perform the actions described in this method, you need to activate the developer mode, since it is turned off by default.
- We go into the program parameters (the procedure is described above);
- Go to section "Customize tape" , in the right side of the window we find item "Developer" , put on the knack and click OK .
Now you can go to the main action algorithm:
- Go to the tab "Developer" , in the left part of which click on the button "Visual Basic" . Also, instead, you can use the key combination Alt + F11 .
- In the editor that opens, click a combination Ctrl + G. that will allow moving the cursor to the area "Immediate" . We write in it the team
Application.ReferenceStyle = XLA1and click ENTER . Note: In the process of a command set, the program will help us with options, as with a manual set of formulas in the cell.
- You can close the editor window Visual Basic. . The table should have come back alphabetic designations of columns.
Many users who have never encountered with it can confuse the situation when the figures are displayed instead of the usual names of columns in the form of Latin letters. But it is not necessary to worry because of this, because to return the coordinate panel to the usual mind can be quite quickly, using one of the ways described above.
Sometimes Excel users see that in the headlines of the columns, instead of the usual letters are worth numbers. More often in ...
Sometimes Excel users see that in the headlines of the columns, instead of the usual letters are worth numbers. Most often, this happens as a result of the fact that the user opened the XLS file with the appropriate settings. We tell how in Excele to change the name of the columns with numbers per letters.
In Excel 2007.
If you are interested in how to change the numbers to the letters in the Excel columns, open the "File" menu and go to the "Parameters" section. In the window that opens, select "Formulas" and remove the checkbox from the R1C1 link style line. Then save the settings. The numbers will replace the familiar notation. Welcome to return back - just put the previous settings.
In Excel 2003.
The essence of the problem is in the included link style R1C1, because of it, the cell addresses are written in another form. If you want to understand how in Excele 2003, change the name of the columns with numbers per letters, do the following:
- Open the "Service - Parameters" menu;
- In the window that opens, go to the General tab, remove a checkbox from the already familiar "Link Style R1C1".
- Now save the settings, the addressing will accept the usual view.
Now there will be no problems with how to replace the sequence numbers in columns to other characters.
Sometimes after starting the Excel program, users find out that the headers of the columns are not indicated, but numbers. As a rule, this happens after the user opened an Excel file with the appropriate settings or someone has changed the settings and did not report it.
In this article we will tell about how to change the numbers on the letters in the headlines of Excel columns. The article will be useful for any version of the Excel tabular processor, including Excel 2003, 2007, 2010, 2013 and 2016.
Before moving directly to solving the problem, we will give a little theory. If not letters are specified in your columns headers, but the numbers (as in the bottom of the bottom), then this means that you have the R1C1 link style.
The R1C1 style is an alternative way to write the cell address. In this method, instead of numbers for rows and letters for columns, only numbers are used. In this case, the cell address is written in the R3C2 format, where R3 is the third row (R - row or row), and C2 is the second column (C - column or column). To make it clearer, let's show how the formula that calculates the sum of two cells will look like if the R1C1 style is enabled.
Now let's move on directly to disabling this function and returning to the usual style of addressing cells. If you use Excel 2003, then in order to change numbers to letters you need to open the "Tools - Options" menu and in the window that opens, go to the "General" tab. The R1C1 Link Style feature will be available here, turn it off and you will revert to the normal style.
If you are using Excel 2007, 2010, 2013 or 2016, then you need to open the File menu and go to Options.
This will open the Excel Options window. Here you need to go to the "Formulas" section and disable the "R1C1 Reference Style" function.
After saving the settings with the "OK" button, the column addressing will change from letters to numbers and you can use the standard Excel style.