Let's talk about how to number lines in Excel

The Microsoft Office program has a special spreadsheet called Excel. The tool is very useful. Among other things, there is a special function - the numbering of strings in Excel. Using this feature in automatic mode, you can see the numbers that will be set slightly to the left of the table itself. However, these numbers are intended solely to indicate the coordinates of cells, and accordingly, when you start printing a table, then you will notice that these elements will not be displayed.

In addition, there is one more nuance: when the user creates a new table, then the specified start can not be placed in the very first column, which passes the automatic numbering. In order to eliminate this problem, many simply add a new single column or a string for numbers. On the one hand, it is possible to enumerate strings in Excel in a similar way, but imagine how much time will be required to prepare for the preparatory actions. In fact, it is not necessary to perform manipulations in manual mode. If, of course, you will know how to number lines in Excel using the functions of the program itself. Today we decided to tell about this.

Independently or automatically

The numbering of strings in Excel can take place in several ways, more precisely, you can perform these actions either manually or in the automatic mode, where the program itself will drive the subsequent number into the table. If you already have the markup created, and you need to add numbers, then in the structure itself you need to create a new column. This is the case if the required field does not exist. In order to add a new column, you should first select the column before which you plan to set the numbers, for this click on its header.

All will do for you

If you do not know how to number lines in Excel in automatic mode, then follow the instructions given, which we are currently describing. After you click on the title, you need to right-click on the designated area and select "Paste" from the drop-down menu, in older versions this item can be called "Add". If you need to place numbers in a horizontal position, then the selection of the line should be made through the context menu, with which you can add a new blank line.

Actions

In the initial two cells you should enter the first and second number, this is done in the column that was previously allocated for numbering. Also for this case the prepared line also approaches. After entering, you must select two cells. In order to decide how to number rows in Excel, you need to perform these manipulations. Now you need to move the mouse pointer over the bottom right corner and select all the areas (there will be only two of them), after this action they will have to change from the usual relief to black flat. When such a change occurs, you need to click the left mouse button and drag the selection border to the most recent cell with your numbering, or rather to the bottom of the table.

Completion

After you release the mouse button, the program in automatic mode should fill the cells with numbers. The above solution to the question of how to number lines in Excel is very convenient, for example, when you need to process a small table. However, with a similar method, you can do and larger projects. Thank you for your attention.