How to Fill a Series with a Linear Trend in Excel

Manually typing a sequence of numbers like 1, 2, 3... or 10, 20, 30... into a spreadsheet is a repetitive task that Excel can handle for you. The "Fill Series" feature is one of Excel’s best simple time-savers, letting you automatically populate a range of cells with a logical data progression. This article will show you three effective methods to fill a series with a linear trend in Excel, from a quick drag-and-drop to more controlled approaches for large datasets.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Exactly Is a Linear Trend?

Before we jump into the "how," let's quickly clarify what a "linear trend" means in this context. A linear trend describes a data series where the values increase or decrease by a constant amount from one cell to the next. Think of it as a straight line on a graph.

For example, this is a linear trend:

• 5, 10, 15, 20, 25 (The value increases by a constant 5 each time).

And so is this:

• 100, 90, 80, 70, 60 (The value decreases by a constant 10 each time).

This constant amount is known as the step value. Understanding this simple concept is all you need to use Excel's fill features effectively. Now let's run through how to create these trends automatically.

Method 1: Use the Fill Handle (The Drag-and-Drop Method)

The Fill Handle is the small green square in the bottom-right corner of a selected cell or range. It's the most common and intuitive way to fill a series for quick, visible tasks.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

When Just One Starting Value is Needed

For a basic numerical sequence that increases by 1 (like 1, 2, 3 or 2024, 2025, 2026), Excel is smart enough to figure out the pattern from a single starting number.

Here’s how to do it:

1. Enter the first number of your series in a cell. Let's use 1 in cell A1.
2. Select the cell (A1).
3. Move your cursor over the fill handle in the bottom-right corner of the cell. Your cursor will change from a thick white cross to a thin black cross.
4. Click and hold the fill handle, then drag it down or across the cells you want to fill.
5. Release the mouse button. Excel will automatically fill the cells with the subsequent numbers in the series.

You’ll see that Excel correctly generated the sequence 1, 2, 3, 4, and so on. This also works for dates (e.g., dragging "Jan 1, 2024" will fill in Jan 2, Jan 3, etc.).

When Two Starting Values Are Needed

What if you need a custom pattern, like increasing by 10 or counting down by 2? To define a specific linear trend, you need to give Excel at least two examples to establish the step value. Let's create a series that increases by 10, starting from 100.

1. In cell A1, type 100.
2. In cell A2, type 110. This tells Excel that the step value is +10.
3. Select both cells (A1 and A2). This is the important part, you're showing Excel the complete pattern.
4. Move your cursor over the fill handle at the bottom-right of cell A2.
5. Click and drag downwards. As you drag, you'll see a small tooltip showing you the value that will be entered into the cells.
6. Release the mouse button once you’ve covered the desired range.

Excel will populate the cells with 120, 130, 140, etc., perfectly following the pattern you established.

This works for decreasing trends, too. If you start with 50 and 45, dragging the fill handle will continue the series with 40, 35, 30, and so on.

Pro Tip: The Auto Fill Options Menu

After you drag the fill handle and release the mouse, a small icon called Auto Fill Options appears. Clicking it gives you more control over the fill action:

• Copy Cells: This ignores the pattern and simply copies your initial selection. (e.g., 100, 110 becomes 100, 110, 100, 110...).
• Fill Series: This is the default for number patterns and what we've been doing.
• Fill Formatting Only: This copies just the cell formatting (like font color, background color, or borders) without changing the values.
• Fill Without Formatting: This fills the series but leaves the destination cells' original formatting intact.

Method 2: Use the "Fill Series" Command

Dragging the fill handle is great for dozens or even hundreds of rows. But what if you need to create a list of 10,000 product IDs? Dragging that far down your worksheet is impractical and slow. This is where the Fill Series command shines. It gives you precise control over your series without any dragging.

Let's use it to create a numbered list from 1 to 5,000 in Column A.

1. Enter the starting value in the first cell. Type 1 in cell A1.
2. Select just that cell (A1).
3. Navigate to the Home tab on the Excel ribbon.
4. In the Editing group (usually on the far right), click the Fill dropdown icon (it looks like a blue down arrow pointing into a box).
5. Select Series... from the dropdown menu. This will open the Series dialog box.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Understanding the Series Dialog Box

This dialog box lets you define the exact parameters of your series:

• Series in: Choose whether to fill down in Columns or across in Rows. We want our list in Column A, so we'll select Columns.
• Type: This defines the type of progression. Select Linear for a constant step value. (Growth is for multiplicative trends, Date for date series, and AutoFill mimics the drag-and-drop method).
• Step value: This is the number to increment by. For a simple numbered list, the step value is 1 (which is the default).
• Stop value: This is where the magic happens. Instead of dragging, you just tell Excel where to end the series. We'll enter 5000 here.

Once your settings are configured (Series in Columns, Type Linear, Step value 1, Stop value 5000), click OK.

Instantly, Excel fills cells A1 through A5000 with the numbers 1 through 5,000. No dragging required!

Method 3: Create a Dynamic Series with Formulas

Both the Fill Handle and the Fill Series command create static lists. Once the values are entered, they don't change unless you manually edit them. If you need a trend that automatically updates when you change the starting value or step value, then formulas are the right tool for the job.

The Basic Formula Approach

The logic is simple: the next value is just the previous value plus the step value. Let’s rebuild our series of 100, 110, 120, etc. using a formula.

1. In cell A1, enter your starting value: 100.
2. In cell A2, enter the following formula:

=A1+10

This formula tells Excel to take the value from the cell directly above it (A1) and add 10.

1. Press Enter. The cell A2 will now show 110.
2. Now, use the fill handle on cell A2 (the one containing the formula) and drag it down.

Excel is smart about copying formulas. When you drag the formula down, it automatically adjusts the cell references. The formula in A3 will become =A2+10, in A4 it will be =A3+10, and so on. This is an example of relative cell referencing and it's what makes this method so powerful.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Making the Step Value Dynamic

You can make this even more flexible. Instead of "hardcoding" the step value (typing '10' directly in the formula), you can reference another cell.

1. Enter your starting value in A1 (e.g., 100).
2. Enter your desired step value into another cell, say D1 (e.g., 10).
3. In cell A2, enter this formula:

=A1+$D$1

The dollar signs ($D$1) create an absolute reference. This means that when you drag the formula down, the reference to A1 will change relatively (to A2, A3, etc.), but the reference to $D$1 will always stay fixed on cell D1.

Now, if you want your series to increment by 15 instead of 10, you don’t have to rewrite any formulas. You just change the value in cell D1 from 10 to 15, and your entire series will update automatically.

Which Method Should You Use?

With three options, how do you decide which one is best for your current task?

• Use the Fill Handle: Best for quick, visual tasks over a relatively small number of cells where dragging isn't cumbersome. It's fast and intuitive for simple patterns.
• Use the Fill Series Command: Use this when you are creating a very large list and dragging is impractical, or when you need absolute precision with your stop value.
• Use Formulas: Choose this when you need a dynamic list that can update automatically if your base assumptions (like the start value or step value) change.

Final Thoughts

Mastering these three fill methods is a small step that brings a massive efficiency boost to your daily Excel work. Whether you're using a quick drag with the fill handle, a precise command for large datasets, or a dynamic formula, you can stop manually entering number patterns and let Excel do the repetitive work for you.

Automating small spreadsheet tasks is great, but creating reports often involves a lot more manual effort, from wrangling CSVs to pulling reports from a dozen different marketing and sales platforms. We built Graphed because we believe businesses should get insights from their data in seconds, not hours. It connects to your existing data sources - like Google Analytics, Shopify, Facebook Ads, or HubSpot - and lets you create real-time, self-updating dashboards by simply describing what you want to see in plain English, putting an end to the reporting grind.