Numerate the rows in Excel 2010
Table editor Excel present in the standard Microsoft Office Suite and is widely used for tabulation, graphing, calculations, calculation functions, data storage. The main purpose of this program is to automate the calculation and processing of data arrays.
Experienced Excel users know many techniques that allow you to perform fairly routine tasks with a few mouse clicks. In particular, this refers to the process of the numbering of the cells. A beginner can spend a lot of time by writing every single number manually. Well, if the table is small. But if you need to number a few thousand rows? In this case, the need for automation of the process is not even questioned.
So, you need to number the cells in the row or column. You can do this in several ways. You can choose the one you like best.
Filling cells with a sequence of numbers
This method is useful if the table is small.
To number rows in Excel 2010 by using this method, you need to do the following:
- in the first cell enter the initial value;
- the second cell should enter the following value;
- next, you need to highlight both cells.
The selection handle you want to drag to the desired number of cells (the square at the bottom of the selected area you want to move in the right direction).
Please note: if in the first cell you enter the digit 2 and second digit 4, the numbering will be on a geometric progression: 2,4,6,8,10… If you drag the selection handle from bottom to top or right to left, then the numbering will be made in the negative direction.
For large tables, this method is not suitable, because drag will be quite uncomfortable. If you want to renumber a large number of rows, use one of the alternative methods listed below.
Microsoft Excel allows you to perform a numeration using two functions. A man, far from mathematics, the term «function» can be intimidating, but nothing overly complicated about this method can not be. You only need to follow a few simple steps.
Video: Promising line numbering
The function «STRING»
This method involves the introduction of a formula using a function called «String»:
- first, in the first cell enter the starting number (e.g. 1);
- in the formula bar enter the following: =ROW(), or use the call functions on the left of the formula bar. If by «Select» you will not find the one you need, you can use the search. Just type in «Search function» the word «String» and press the «Find» button;
- can only drag a selection handle for the desired number of cells.
The function of «Progression» with the indication of limit values
This method is useful if the table is bulky and drag uncomfortable.
- first, it should be in the cell to specify a seed number;
- next, you should call a function called «Progression»;
- you need to enter the direction in which it will fill (row or column), type of progression (arithmetic, geometric) and the step of filling (the number of which will increase the previous value) and the number of cells that will be numbered.
Note: When the cell is filled, to make the further numeration will be possible by dragging the cursor (similar to that described in the first method).
The function of «Progression» select the range of cells
This method is similar to that described above, however it involves the use of function values «Progression», not default. These values are tuned for regular, the most common numbering.
So, if you need to number the cells in the column from 1 to 10, you should do the following:
- specify in the cell the initial value (in our case 1);
- to select a region with the number of cells that need to be numbered (in our case 10);
- to call the function «Progression» and click «OK» .
Now you know how to number rows in Excel 2010 in four ways. Perhaps in the future the developers will offer some more solutions to this common problem.
The more ways to automate various operations in Excel you will know, the more time it can save in the process of working with data. You will save yourself from routine, will be able to quickly solve problems and increase efficiency.