Autofill Fill Cells: How It Works in Excel & Sheets

Autofill fills cells by extending a pattern from one or more selected cells into adjacent cells, saving you from typing repetitive data. You enter a starting value (like “January” or “1”), drag the fill handle, and the software completes the series (February, March… or 2, 3, 4…). This article explains exactly how Autofill behaves in Microsoft Excel and Google Sheets, how to control it, and how to fix it when it does something unexpected.

Formula

Autofill isn’t a numeric formula—it’s a pattern-recognition feature. The software looks at the selected cell(s) and guesses the next value based on the type of data:

• Numbers: If you select 1 and 2, Autofill continues 3, 4, 5… (increment = difference). If you select only 1, it repeats 1, 1, 1… unless you hold Ctrl (Excel) or use the fill options.
• Text with numbers: “Item 1” becomes “Item 2”, “Item 3”, etc.
• Dates: “Jan 1” becomes “Jan 2”, “Jan 3″… (daily increment). “Monday” becomes “Tuesday”, “Wednesday”…
• Custom lists: Excel has built-in lists like days, months, and can learn custom lists you define.

The underlying rule is: if the selected range shows a clear arithmetic or date pattern, Autofill uses that pattern; otherwise it copies the value.

Worked Example

Let’s use the default values from the calculator above: you ran 10 km in 50 minutes. That’s not an Autofill example, but it shows how the same logic of extending a pattern applies to a simple calculation.

1. Enter distance = 10 km, time = 50 min.
2. Pace = time / distance = 50 / 10 = 5.0 min/km.
3. Speed = distance / (time / 60) = 10 / (50/60) = 12.0 km/h.

The calculator returns pace 5.00 min/km and speed 12.00 km/h. Autofill would do the same kind of extension: if you had two rows with distances 10 and 20 km, and you selected both, Autofill might continue 30, 40… but it won’t compute pace for you—that’s what the formula does.

How Autofill Works in Excel

In Excel, the fill handle is a small square at the bottom-right corner of the selected cell. When you hover over it, the cursor changes to a thin cross. Drag it down, up, or across to fill cells.

• Default behavior: Drag without any key to extend the pattern. If you select “Jan” and drag, you get “Feb”, “Mar”… If you select a single number, you get repeated copies.
• Ctrl key: Hold Ctrl while dragging to toggle between copy and series. For example, select 1, hold Ctrl, drag → you get 2, 3, 4… (series). Without Ctrl, you get 1, 1, 1… (copy).
• Right-click drag: Drag with the right mouse button and release to see a context menu with options like Fill Series, Fill Formatting Only, Fill Without Formatting, and more.
• Double-click the fill handle: If you have data in an adjacent column, double-clicking the fill handle fills down to the last row of that data—a huge time-saver.

How Autofill Works in Google Sheets

Google Sheets behaves similarly, but with a few differences:

• Fill handle: Same small square in the bottom-right corner. Drag to fill.
• No Ctrl toggle: Instead, after dragging, a small Autofill icon appears at the bottom-right of the filled range. Click it to choose Copy, Fill Series, Fill Formatting Only, etc.
• Series detection: Sheets is good at detecting patterns. If you enter 1, 3, 5 and drag, it will continue 7, 9, 11.
• Double-click: Also works in Sheets to fill down to the last row of adjacent data.

How to Choose the Right Fill Method

To get the result you want, you need to know which method to use:

• Copy the same value: Select the cell, drag the fill handle without any modifier (if it’s a number) or use the right-click drag and choose “Copy Cells”.
• Continue a series: Select at least two cells that show the pattern (e.g., 1, 2 or Mon, Tue), then drag. Or use the right-click menu and pick “Fill Series”.
• Fill formatting only: Use the right-click drag and choose “Fill Formatting Only”—this copies the cell style but not the value.
• Fill without formatting: Use the same menu to copy values but not the formatting.

Common Problems and Fixes

Autofill often surprises users. Here are typical issues and how to solve them:

• It copies instead of continuing the series. If you select only one cell with a number, that’s expected. Select two cells (e.g., 1 and 2) or use the right-click menu → Fill Series.
• It continues a series when you wanted a copy. Hold Ctrl while dragging (Excel) or use the Autofill options in Sheets to switch to Copy.
• Dates increment by day instead of month. If you select “Jan” and drag, you get months. If you select “1/1/2025” and drag, you get days. To get months, right-click drag and choose “Fill Months”.
• It fills down too far or not far enough. Double-click the fill handle to fill to the end of adjacent data, or drag manually to the exact range.
• It skips a pattern. For example, you want 1, 3, 5… but you only selected 1 and 3. That works. But if you select 1 and 2, you get 3, 4, 5… If the pattern isn’t clear, select three cells.

Custom Lists and Advanced Uses

Excel lets you define custom lists so Autofill recognizes your own sequences, like product codes or team names.

1. Go to File → Options → Advanced → Edit Custom Lists (Windows) or Excel Preferences → Formulas and Lists → Custom Lists (Mac).
2. Enter a list (e.g., North, South, East, West) and click Add.
3. Now when you type “North” and drag, you get South, East, West.

Google Sheets doesn’t have custom lists, but you can use formulas like =SEQUENCE() or =ARRAYFORMULA() to generate series.

Frequently Asked Questions

Why does Autofill copy instead of filling a series?

Because you selected only one cell with a number. Excel and Sheets need at least two cells to detect a pattern. Select two cells that show the increment (like 1 and 2) and drag again. If you want to force a series from a single cell, hold Ctrl while dragging in Excel, or use the right-click drag menu and choose “Fill Series”.

How do I autofill without changing the formatting?

After dragging, look for the Autofill options icon (Excel) or the small menu (Sheets). Choose “Fill Without Formatting” (Excel) or “Fill values only” (Sheets). Alternatively, use the right-click drag and select the same option.

Can Autofill skip weekends or holidays when filling dates?

Not by default. Autofill fills consecutive days. To skip weekends, you can use the WORKDAY function in Excel or Sheets: =WORKDAY(start_date, 1) and drag that formula down. For holidays, you need to provide a list of holiday dates to the function.

How do I autofill a formula down an entire column?

Enter the formula in the first cell, then double-click the fill handle (the small square) in the bottom-right corner of that cell. It will fill down to the last row of data in the adjacent column. If that doesn’t work, drag the fill handle manually to the desired range.

Why does Autofill show a weird pattern like 1, 2, 3, 4, 5… but I wanted 1, 3, 5?

Autofill detects the pattern from the selected cells. If you selected 1 and 2, it assumes +1. To get odd numbers, select 1 and 3, then drag. If you already dragged, you can use the right-click drag menu to choose “Fill Series” and specify the step value.

Can I autofill across multiple sheets at once?

No, Autofill works within a single sheet. To fill the same range across multiple sheets, you can group the sheets (hold Ctrl and click sheet tabs), then enter the data or formula—it will appear on all selected sheets. But Autofill dragging only affects the active sheet.

Related

• Wacom No Device Connected: Fixed?
• Keep AI Coding Agents Away from Env Secrets
• Best All-in-One Ink Tank Printer: Which Fits You?

in t | Finish time | min | 50 | 0
in d | Distance | km | 10 | 0
out pace | Average pace | min/km | t / d | 2
out speed | Average speed | km/h | d / (t / 60) | 2