Skip to playerSkip to main content
Stop manually typing numbers! Learn the fastest Excel formula to generate a series from 1 to 100 instantly using the SEQUENCE function. If this helped you, hit the LIKE button and SUBSCRIBE for more weekly Excel tips!
Hashtags
#ExcelTips #ExcelFormulas #Productivity #Excel2025 #MicrosoftExcel #SpreadsheetHacks
Transcript
00:00In the modern world, the most efficient way to generate a number series from 1 to 100 in Excel is by using a dynamic array formula.
00:09Enter this formula in a single cell and it will automatically spell down to create number 1 to 100 in a column.
Comments

Recommended