If I understand correctly, you can do this a couple of ways.
You can do it manually, after inserting whatever rows you want, select the top cell of the column, click and hold the black square in the lower right of the cell, and drag to the bottom of the data. Excel will automatically fix the sequencing.
If you want to do it automatically with a formula, you first need the data to be in a named range or table, and use:
where the -1 is optional to however many rows your data is offset from the actual row number.
Bookmarks