How in "Excel" to number lines automatically

Often, when working in the Excel program, especially when creating a large database, the user needs to number all the lines so that it is easier to carry out a visual search of the desired one. The program has special tools for this, which will be discussed now. To be more precise, in the article we will talk about how to automatically number the lines in Excel in three different ways.

First method: stretch method

The first method presented, as in "Excel" to number the lines, is considered the most simple by right. It is they who are used most often. Let's go directly to how to do this.

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

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

3. , .

4. , , .

, , . , "" , , , , .

:

, . , , , . , , "" .

, , "" , :

1. , .

2. .

3. : "=(A1)".

4. ENTER.

5. , , , , , .

. , , , , , . - , .

:

, , , . , , "" .

, :

1. 1.

2. "", "".

3. , , "".

4. . " ", "", - "1", , .

5. "".

. , , .

, "". - , , .