Forum Discussion

UKdeejay's avatar
UKdeejay
Copper Contributor
Sep 16, 2024

'Open-ended' sequential numbering of Rows in Excel...

I have been looking at the SEQUENCE function but, if I understand it correctly, you need to enter an end point for how many sequential numbers you want Excel to autofill (e.g. 1 to 1000)? 

Is there a way to get Excel to autofill a sequential number when new data is entered in a Row?

For example, Column A is sequential numbers starting with '1' (without the ' ' inverted commas) in A1, then 2 in A2 etc and every time data is entered in a new Row in Column B (for example), a new sequential number is entered automatically in the same Row in Column A? TIA

Resources