Summary of the question: if we have 1 in cell A1, and 2 in cell A2, is there a way to make 1 and 2 continuously fill to A1000, with 3 in A3, 4 in A4, …, and 1000 in A1000, without the user dragging it all the way to the cell A1000.
If there are some calculations, such as mortgage or compound interest, and we need to see the results for 30 years, we may start by create 2 rows.
And then we select row 2 and then drag the bottom-right corner of the selection to make it auto-full all the way to row 20, and then to 40, 60, …, then all the way to 360, and we can see the result.
Do we have to repeat this tedious task of repeating it 18 times? Drag it, scroll the page, drag it, scroll the page, etc., etc.
Is there an automatic way to just select row 2, and tell Google Sheet to "copy it" or "extend" or "auto-fill it" for the next 360 rows?
Otherwise, if we notice an error in a cell in row 2, then now we have to drag it to row 60, 120, 180, …, again, little by little, all the way to 360.
Best Answer
In cell A1, enter this formula:
=ARRAYFORMULA(ROW(A1:A1000))This will populate every cell in Column A with its respective row number (which is the value that you have specified).
ROW(A1:A1000)alone will only populate the value in Cell A1.ARRAYFORMULA()enables the array value to populate throughout the array.