Forum Discussion
autofill
How to autofill cells in a row depending on a serial number in the first cell? Like by filling the serial number in the first row I can get the data for the next series of rows.
When you, for example, enter the first number 1234 in A1 you can enter =A1+1 in B1 and drag it across as far as needed.
Alternatively, first format A1 as a text, then enter 1234 and drag it across. Excel automatically increments the 'number' by one.
Or, if you want to be a bit more sophisticated (and on a modern Excel version) and want to start with the number 1234 and add 10 cells on the same row with increments of 1, do this:
=SEQUENCE(,10,1234)