How to Create an Uninterrupted Sequence in Microsoft Excel

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 an uninterrupted sequence in a column. 1. Enter the formula: =ROW()-1 in the first cell of the sequence column. […]