How to let the serial number not change in the Excel2013?

After entering the numeric number in the Excel2013, every time we insert or delete the rows of the worksheet, we will make the original good serial number become unrecognizable, look at the pain of saying. But did you find out? No matter how we modify the row of the worksheet, its line number is always constant, so if you want to change the serial number, then hang it with the line number.

Detailed procedures are as follows:

1, with Excel2013 open a worksheet, the following figure, our task is now in a column insert do not randomly change the serial number. Select the A2 cell, where you enter the function "=row ()-1", and the row () function is to get the line number.

2, press the Ctrl+enter key combination, will get the value of the function, we now put the mouse to the lower right corner of the A2 cell, when the cursor becomes a cross state, press the mouse and drag down to A8 cell. When we release the mouse, you can see that the A3-a8 cell has been automatically populated with the ordinal number.

3, so far, our task has been completed, and now we have to test the effect. First select the 3rd row of the worksheet, and then switch to the Start tab, and then click the Delete button in the Cells group.

4, we can see that the previous 3rd line was deleted by us, but the serial number of this line also, 2, and no changes, the effect is as follows.

Tip: You learn to use the row () function more.