Slider

How to Create an Uninterrupted Sequence in Microsoft Excel

Date:2020-2-16 Author:Cordelia

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.

How to Create an Uninterrupted Sequence in Microsoft Excel

2. Press [Enter] or click anywhere outside the cell to see the result. Then drag the mouse to use fill handle applying the formula to other cells in the column.

How to Create an Uninterrupted Sequence in Microsoft Excel

3. Now you can try inserting rows or deleting rows in this spreadsheet, the sequence won’t be interrupted at all.

How to Create an Uninterrupted Sequence in Microsoft Excel

If you find our content useful, donations are always welcom. we'll keep going and hold more giveaways in the future.

Windows 10: Run Troubleshooter to Fix Network Connection Problems
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *