Forum Discussion
How do I enter a number in one cell that automatically fills all cells below numerically
I have a 4 page spreadsheet with labeled columns at the top of each page. I need help on how to formulate the first cell in a column on page 1 so that all cells below automatically fill in numerical...
Enter a formula like this in the cell in row 2:
=SEQUENCE(number_of_rows, , first_number)
For example, if you want 100 rows, with the numbers 101, 102, ..., 200:
=SEQUENCE(100, , 101)