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