Microsoft Office has a special spreadsheet editor called Excel. The tool is very useful. Among other things, there is a special function - line numbering in Excel. Using this feature in automatic mode, you can see the numbers that will be installed a little to the left of the table itself. However, these numbers are intended solely to indicate the coordinates of the cells, and accordingly, when you start to print the table, then you can notice that these elements simply will not be displayed.
In addition, there is one more nuance: when the user creates a new table, then the specified start may not fit in the very first column, which goes through automatic numbering. To fix this problem, many simply add a new single column or row for numbers. On the one hand, it is possible to number rows in Excel in this way, but just imagine how much time you need to take the preparatory steps. Actually, manual manipulations are completely unnecessary. Unless, of course, you will know how to number rows in Excel using the functions of the program itself. Today we decided to tell about it.
Independently or automatically
Numbering of lines in Excel can take place in several ways, or rather, you can perform these actions either in manual mode - this is routine work, or in automatic mode, where the program will drive the next number into the table on its own. 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 if the required field does not exist. In order to add a new column, you should first select the column in front of which you plan to set the numbers, for this, click on its heading.
They will do everything for you
If you don’t know how to number lines in Excel in automatic mode, then follow the instructions that we are currently describing. After you click on the title, you need to right-click on the designated area and select the "Paste" command in the drop-down menu, in older versions this item may be called "Add". If you need to place the numbers in a horizontal position, then the line should be selected through the context menu with which you can add a new empty 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, a prepared line is suitable for this case. After entering you need to select two cells. In order to solve the question of how to number rows in Excel, you will need to perform these manipulations. Now you need to move the mouse pointer to the lower 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 plus to black flat. When such a change occurs, you need to click the left mouse button and drag the selection border to the very last cell with your numbering, or rather, to the bottom of the table.
Completion
After you release the mouse button, the program in an automatic mode should fill the cells with numbers. The above solution to the question of how to number rows in Excel is very convenient, for example, when you should process a small table. However, with a similar method you can do larger projects. We thank you for your attention.