Python's range() function generates a sequence of numbers in one line. Excel's Fill Series feature does the same — but extends it to dates, growth curves, and auto-recognized patterns. Understanding the full Fill Series dialog moves you beyond simple drag-to-fill into precise, professional sequence generation.
Part 1: The Fill Handle and Its Hidden Options
The small square at the bottom-right corner of a selected cell or range is the Fill Handle. Most users know you can drag it to extend a pattern. But right-clicking while dragging reveals the full menu of options:
| Right-Click Option | What It Does |
|---|---|
| Copy Cells | Repeats the exact value (no incrementing) |
| Fill Series | Increments based on detected or configured pattern |
| Fill Formatting Only | Copies cell format, not content |
| Fill Without Formatting | Fills content, strips source formatting |
| Fill Days / Weekdays / Months / Years | Date-specific increments |
| Linear Trend | Fits a straight-line trend through selected values |
| Growth Trend | Fits an exponential growth curve through selected values |
Part 2: The Fill Series Dialog
For full control, use the dialog: Home tab > Fill (in the Editing group) > Series.
Key Settings
Series in: - Rows — fills across columns (horizontally) - Columns — fills down rows (vertically)
Type:
| Type | Description | Example |
|---|---|---|
| Linear | Adds the Step value each time | 10, 20, 30, 40 |
| Growth | Multiplies by the Step value each time | 10, 100, 1000, 10000 |
| Date | Increments by the selected Date Unit | Jan, Feb, Mar |
| AutoFill | Lets Excel detect the pattern | Mon, Tue, Wed / Q1, Q2, Q3 |
Date Unit (only active when Type = Date):
| Unit | Increments by |
|---|---|
| Day | One calendar day |
| Weekday | Skips Saturday and Sunday |
| Month | One calendar month |
| Year | One calendar year |
Step value: The amount to add (Linear) or multiply by (Growth) at each step.
Stop value: Fills until reaching this number or date. Excel stops automatically — you don't need to pre-select the destination range.
Part 3: Practical Examples
Example 1 — Fiscal Quarters
Type Q1 in a cell. Open Fill Series, set Type: AutoFill, Stop value: Q4.
Result: Q1, Q2, Q3, Q4.
Example 2 — Weekday-Only Date Sequence
Type a start date. Open Fill Series, set Type: Date, Date Unit: Weekday, Stop value: [end date]. Result: A list of only Monday–Friday dates, skipping weekends — perfect for business day schedules.
Example 3 — Monthly Revenue Targets (Growth)
Type 100000 as your starting revenue target. Open Fill Series, set Type: Growth, Step value: 1.1, Stop value: 200000.
Result: 100000, 110000, 121000, 133100... (10% growth each period) until 200000 is reached.
Example 4 — Linear Sales Projection
Select two cells containing your first two data points (e.g., 50 and 75). Open Fill Series, set Type: Linear, Stop value: 200. Result: 50, 75, 100, 125, 150, 175, 200.
Part 4: Trend Projection (Extend Existing Data)
If you have existing data and want to project the trend forward, select the existing values AND the empty destination cells together, then open Fill Series and check the Trend checkbox. Excel will calculate the best-fit linear or growth projection automatically.