Quick Links
Filling sequential data in Google Sheetsis easy using the fill feature.
Want to fill both columns and rows in a range?
Want to start at 525 and decrease each number by 18?
How about doing both of these using dates?
These are the types of things you might do with the SEQUENCE function in Google Sheets.
About the SEQUENCE Function
The syntax for the function is
where only the first argument is required.
Rows: The number of rows you want to fill.
Columns: The number of columns you want to fill.
If omitted, the formula assumes one column.
Start: The number to begin the sequence.
If omitted, the formula starts at 1.
Step: The amount to increase or decrease each number in the series.
If omitted, the formula increases each number by 1.
But if it’s crucial that you fill a series ofdates, it works.
Notice the date argument is in quotes.
