Advice 1: As in Excel to rename the column

In Microsoft Office Excel a single cell or the whole table can be given a custom name. Most often this opportunity for easy access to named data from formulas to indicate every time'. To appoint and to change the assigned areas of the spreadsheet the names are simple enough, it can be done in several ways.
As in Excel to rename the column
You will need
  • The table editor Microsoft Office Excel 2007 or 2010.
Instruction
1
Select a named scope, whose name you want to change. If it's a column, click its header. Above the table, above the column headings, there is a formula bar. In the left field of this line shows the address of the current cell. After selecting a named range or single cell address in it needs to be replaced has the range name. If after separation of the column this has not happened, so the name has not the entire column, and a particular group of cells. Gradually releasing cells of the column from the top down, wait until the name appears in this box and proceed to the next step.
2
Select the column name in the left box of the formula bar and type a new one. Use the letters of the Russian or Latin alphabet, digits and the underscore, whose total number must not exceed 255 characters. When you are finished inputting, press Enter, and a new name for the selected area will be assigned.
3
The second step can be replaced by the use of dialogue with more detailed settings for naming cells. To his cause, go to the Formulas tab and in the group of teams "Defined names" open the drop-down list "Assign name". The desired item in this list is named the same way - "to name".
4
In the Name field of the dialogue "creating a name" type the new name column. In the drop-down list "Region", select the individual sheet or the entire workbook, formulas which should be able to use that name. In the field "note" can be typed explanatory text. The value in the field "Range" change is not necessary, since Excel has already put in the address of the selected range. Click OK and the name column will be changed.
5
Often under the change of name of the columns imply a very different operation - shift method of addressing. By default, columns in the Excel table are designated by Latin letters, which are used as column addresses. Letter symbols can be replaced by numbers. If you need to make exactly the same or the opposite action, do it via Excel settings. In the 2010 version of the open menu using the button "File" and select "Options". In 2007 this button is called Office, and to access the settings need to click in the menu button "Options Excel".
6
Go to "Formulas" settings window editor and in the section "Working with formulas", check or uncheck the box "R1C1 reference Style". Click OK, and the addressing method of the column headers will change.

Advice 2 : How to change the Excel numbers on the letters

Most users of the table editor Microsoft Office Excel was used to line numbers on its pagesAh are denoted by numbers and columns by letters identifitseerida. However, this is not the only way of referencing table cells - when the alternative option, and the rows and columns are numbered. Link to a specific cell in this style of numbering consists of two numbers, the first of which corresponds to the page number and before it is written with the letter " R " (Row - row) and the second the column number and it is preceded by the letter C (column - column).
How to change the Excel numbers on the letters
Instruction
1
Change the style of the links in the table settings editor if you want to replace the numbers in the columns on lettering. This setting is saved in a file with the table, so opening a table from a file that you load and the setting - Excel will read it and bring into line the numbering of the columns. Opening a file created with a different value for this setting, you will see a different style of numbering columns. This implies that the change you unusual style of links can be, and is not necessary - it is sufficient to close the table with the "wrong" numbering and everything will return to normal. If, however, such a need exists, then proceed to the next step.
2
Open the main menu of the table editor by clicking the large round button in the upper left corner of the window. At the bottom there are two buttons, one of which is placed the inscription "Excel Options" - click it. All this can be done without using the mouse - the main menu can be opened by pressing the ALT key first and then key "f" and select the button to access the Excel options by pressing the "M"button.
3
Select "formula" in the left toolbar of the settings window. Among the sections of the installations related to entering formulas, you need to find the section "Working with formulas". The first checkbox in the section marked that says "R1C1 reference Style", and specifies how the designated column in the pages table editor. To replace the number of letters you need to remove the check mark from this field. This manipulation can also be performed using mouse and keyboard - pressing ALT + 1 replaces clicking the checkbox.
4
Click "OK" to commit you have made to settings changes and Excel will change numbers in the headers of the columns on letters.
5
If you are using earlier versions of Excel round button access the main menu you will not find. In Excel 2003, you should open "Settings" in the menu and on the "General" tab, find and change the same setting "R1C1 reference Style".

Advice 3 : How to change Excel columns

After filling in the data of rows and columns of spreadsheets in Microsoft Office Excel available to the user various operations with them. It can be not only manipulation of individual cells, but entire rows or columns. In particular, they can duplicate, delete, move, or swap - this operation is quite simply implemented in Excel.
How to change Excel columns
You will need
  • The table editor Microsoft Office Excel version 2007 or 2010.
Instruction
1
Use a combination of the operations of cut-and-paste, to swap two columns of the table. To do this, first select one of them by clicking the title of the cage with Latin letters above the top cell of the column. Then either press Ctrl + X or right-click the selection and click the Cut command in the context menu.
2
Select by clicking on the title of the other column involved in the operation of the exchange. Open the shortcut menu by clicking the highlighted area, right-click, and select "Insert cut cells". This command is duplicated in the drop-down list to Insert, placed in the group of "Cell" Home tab in the menu of the table editor, you can use this method of insertion.
3
If you want to swap two columns and, for example, six, then you can do the previous two steps the necessary number of times, and you can cut and move a group of columns. For this allocation and click all headers of the group of columns while pressing Ctrl. If these columns a lot, then clicked each of them is not necessary - select the first, press Shift and click the last header. And after selecting the first column click the right arrow, Shift-up till selected would not be full range speakers. Other operations - cutting and pasting - with the manipulation of the group columns do not differ from those described in the previous two steps.
Note
If a table cell encapsulated formulas that use references to moveable columns, then pay attention to the change of the calculated formula values. Some Excel functions are not able to automatically track changes in the positions involved in the calculation of cells, especially if they are assigned their own names.

Advice 4 : As in Excel to change the name of columns

Each cell in Excel has certain coordinates. Columns of the table are designated by Latin letters, rows by numbers. This allows you to quickly find the desired data is located in cells A6 or B8. The need to rename columns does not occur very often. For example, the user has mastered the program, accidentally put a check mark and instead of the Latin letters now numbers. A similar problem sometimes occurs when opening a table, made on a different computer.
As in Excel to change the name of columns
You will need
  • - computer with Microsoft Excel.
Instruction
1
Marking columns in Excel is closely linked with the display mode reference. Reference in the programme is the address of the cell. The reason that the columns were renamed, just is using a different style for these addresses. The main thing in this situation – not to get lost, even if you do not confidently know. You need to find an extra "bird", which another user or even you have set the wrong places. If you are still afraid to spoil the document, copy it under a different name and experiment on the copy.
2
Open the document in Microsoft Excel. At the top of the screen you see the main menu. The interfaces of most programs from Microsoft have a lot in common. Having mastered one, you quickly learn to understand and other. Locate the "tools" tab. Clicking on the labels with the mouse, you will see a drop-down menu. Find the line "Options". In some versions this feature is called "Excel Options".
3
You will see a window with some tabs. If you have installed the program, version 2003, find the "General" tab and the "R1C1 reference Style". In the small window you will see "bird", which must be removed, and then all the columns will get the usual letter names.
4
In later versions of Excel, the procedure is the same, but some functions have different names. Exactly the same as in the previous case, log in to "Tools" and open "Options". Instead, the General tab locate the "Formulas" and then "R1C1 reference Style". Remove the "bird".
Useful advice
If you want to change the column names to numbers, we must act in the same manner, by setting a "tick" in the right place. But, such a need occurs rarely.

To change the column names using a macro, but only if you are already very confident working with this program.
Is the advice useful?
Search