Make Office Better
Top tips for the best office programs
MICROSOFT EXCEL
Create number sequences in spreadsheets
In Excel 2021 (and Microsoft 365), Microsoft added the =SEQUENCE function to let you easily generate a list of sequential numbers in an array of cells. For example, typing =SEQUENCE(10) fills the numbers 1 to 10 vertically in a single column, while =SEQUENCE(1,10) fills them across 10 columns horizontally.