But often you want to have a column that also includes either a row number or some other kind of increasing sequence of serial numbers. You can do this using the ability in Excel to continue a ...

Before you use the SEQUENCE and COUNTA functions together to create this scenario, ensure the data is not formatted as an Excel table ... Ctrl+Shift+Down to select the remaining numbers.