EXCEL sequence

A2 for 1, A3 2, and so on, how automatically generated numbers? If you need to add or delete his party, then how to operate?

in the A2 type
= ROW () -1
copied to the following formula to the needs of the cell, and automatically generate the code.

to remove his party, it will automatically re-count, The correct sequence of numbers does not affect.
Added his party, it will automatically re-count, but without his new number, you only need to copy the formula to the first line of blank cells on the line.In the two recommended Methods:
1.Select the A2 and A3, move the cursor to the lower right corner of the A3, when the cursor into a solid black cross, hold down the cursor to drag down.Such a commonly used method is simple, but In the middle you add or delete his party, the following line will not automatically increase or decrease.
2.In A2 enter = ROW () +1 determined by the carriage return and then move the cursor to select A2 and A2 to the right Below, when the cursor into a solid black cross, hold down the cursor to drag down.This method when you add or delete in the middle of his party, the following line will automatically increase or decrease.Try it, I wish you Success.As long as you fill in a Department A2, A3 in the Department to fill 2, the A1, A2 and drag, when you see you can fill in the 1-2 occurring at a black frame, the bottom-right corner of the box?????, The mouse pointer into a cross, this time as long as you hold down the left and go under the trailer, you have to wait, how many will do.If you need to add or delete his party, if you choose to delete or by the location of the line, Select the Insert menu, or you can delete the line operation.