When inserting or deleting some rows to Excel spreadsheet, the sequence number will be interrupted and become incoherent, which could also affect your counting. In fact, you can use a very simple Excel formula to create anin a column.
1. Enter the formula: =ROW()-1 in the first cell of the sequence column.
2. Press [Enter] or click anywhere outside the cell to see the result. Then drag the mouse to useapplying the formula to other cells in the column.
3. Now you can try inserting rows or deleting rows in this spreadsheet, the sequence won’t be interrupted at all.