🔢 The Number Fabricator

Goal: Generate a list or grid of numbers instantly.
SEQUENCE creates an array that "spills" into neighboring cells automatically.

Rows: -
Cols: -
Start: -
Step: -
(Waiting for Formula...)
Ready...

💻 Formula Structure

=SEQUENCE(rows, [columns], [start], [step])
  • 1. Rows: How many rows down?
  • 2. Columns: (Optional) How many columns across?
  • 3. Start: (Optional) Starting number (Default 1).
  • 4. Step: (Optional) Increment amount (Default 1).
-- Generate dynamic array
=SEQUENCE( 10, 1, 1, 1 )
Spill Result:
-

⚠️ The "Spill" Error

🚫 #SPILL! Error
This formula needs empty space to expand. If there is any data in the way (even a single character), Excel returns #SPILL!. Clear the path to fix it.
💡 One Formula
You only type this formula in the top-left cell. You cannot delete individual cells in the spill range; you must delete the original formula.