As in the "Excel" number the lines automatically


Often, working in the Excel program, especiallycreating a large database, the user needs to number all the lines so that it is easier to perform a visual search of the desired one. In the program there are special tools for this, which will now be discussed. To be more precise, in the article we'll talk about how to automatically number the lines in "Excel" in three different ways.

how to number lines in an Excel

The first way: the method of stretching

The first method presented, as in the "Excel" number lines, is considered by right the simplest. They use it most often. Let's go directly to how to do it.

  1. In the table you need to number the first two lines, for example, having entered numbers 1 and 2 in them.

  2. Then you need to select these two cells by holding down the left mouse button on the first one and dragging the cursor to the second one.

  3. Now we need to click on the bottom right corner of the selection, it is usually displayed with a special square.

  4. Holding the left mouse button, it remains only to drag the selection to the cell where the numbering should end.

how to number lines in excel

By releasing the left mouse button, you will see that everythingthe lines are numbered. This way, as in "Excel" to number the lines, is very simple and will not cause any difficulties, but it is not very suitable in cases where it is necessary to number more than a hundred lines, because pulling them all will be quite long and inconvenient.

The second way: using the function

In this method, we will use the function,as you can guess by the title of the subtitle. An inexperienced user often bypasses them, since it seems to him that the use of functions requires great knowledge, but this is not at all the case. Especially, using a simple instruction, the number of lines in "Excel" will be exactly the first time.

So, talking about how to "number" the dates in Excel using the function, you need to do the following:

  1. Place the cursor in the cell with which the line numbering should start.

  2. Double-click on the cell.

  3. Enter the following expression: "= LINE (A1)".

  4. Press ENTER.

  5. Now, as in the previous method, you need to move the cursor to the bottom right corner of the cell selection and, holding the left mouse button, drag the cursor to the cell where the list should end.

how to automatically number the rows automatically

As a result, you will receive numbered lines. However, it's easy to see that this method is not much different from the first, the difference is that you need to allocate not two cells, but only one, but you need to enter the formula itself longer. In some situations, this method can still come in handy, so do not deprive it of attention.

The third method: application of a progression

Earlier it was said that methods with stretchingAllocations are good only in cases where you need to number a few lines, and for long tables they do not fit. So, now we will consider how to "number" the rows in Excel with the help of a progression.

So, for this you will need:

  1. Select the first cell and enter the number 1 there.

  2. Click on the "Fill" button, which is on the toolbar in the "Home" tab.

  3. From the list that appeared, select the "Progression" item.

  4. In the appeared window you need to ask allnecessary parameters. Place the position "by columns", type "arithmetic", step - "1", and specify the limit value equal to the rows that need to be numbered.

  5. Click OK.

how to automatically number the rows automatically

After that, the lines you specify will be numbered. As you can see, this method works best when you need to enter line numbers in a huge number of cells.


Now you know all three ways how to number the lines in "Excel". The proposed methods to some extent differ from each other, and this is undoubtedly good, because there is plenty to choose from.

Comments (0)
Add a comment