Filling sequential data in Google Sheets is easy using the fill feature. But if you want to increase or decrease the numbers in your series or fill all cells in an array, consider the SEQUENCE function.
While the SEQUENCE function can perform much the same way as the fill feature, it’s the optional arguments that make it most useful. 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 can do with the SEQUENCE function in Google Sheets.
About the SEQUENCE Function
The syntax for the function is SEQUENCE(rows, columns, start, step) 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….
Read Full Article Source
