How to insert serial numbers into the table?

Method: 1. Open the excel table; 2. Select a column and enter "1" and "2" in the first two cells; 3. Place the mouse in the lower right corner of the "2" cell ; 4. When the mouse cursor turns into a "black cross" cursor, just press the left mouse button and hold down the drag.

Method:

First open Excel 2007 and create the content as shown in the picture. Of course, you can also choose the content of exercises according to your actual situation. For the purpose of explanation, two columns are specially created here. The first column is the "serial number" and the second column is the "name".

Then enter "1" and "2" in the cells below the "Serial Number". Then select these two cells and move the mouse to the selected cells. In the lower right corner of the cell, when the mouse turns into a "black cross" cursor, press and hold the left mouse button while dragging to the last row of content and then release the mouse. You will find that all cells under the serial number are automatically filled.

Right-click on the row with the serial number "3", select the "Insert" option to insert a new row, and then select "1" and "2" under the "Serial Number" row "For these two cells, place the mouse in the lower right corner of the selected cell. When the mouse turns into a "black cross" cursor, press and hold the left mouse button while dragging to the last row of content and then release the mouse. You will find that all the cells under the serial numbers automatically complete the filling of the serial numbers.

Of course, if there are many rows of records, this method of generating serial numbers will be troublesome. A better way is to use formulas to achieve this. First delete all the content under the serial number column, and enter the formula "=Row()-1" in the first cell below the serial number column.

Put the mouse to the lower right corner of the cell. When the mouse turns into a "black cross" cursor, press and hold the left mouse button while dragging it to the last row of content and then releasing it. Use the mouse. You will find that all cells under the serial numbers are automatically filled in.

Right-click on the row with the serial number "3" and select " Delete" option, select "Entire row" in the pop-up window, and you will find that all serial numbers are automatically generated and ordered.

Right-click on the row with the serial number "3" and select the "Insert" option from the pop-up menu. Select "Entire Row" in the window.

Finally, copy the cell formula with the serial number "3" below, and you will find that all the cells in the serial number column are in order. Arranged.

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to insert serial numbers into the table?. For more information, please follow other related articles on the PHP Chinese website!