Basic AutoFill Options in Excel: Which One to Use

Why does AutoFill sometimes copy your entry and other times extend it into a sequence? That question shows up in the Excel subreddit almost every week, and the answer isn't buried in settings. It's in how AutoFill reads your data before you ever drag.

This guide covers the autofill excel basics: how the fill handle works, when to use Ctrl+D instead of dragging, and how to build a custom list so Excel recognizes your own repeating patterns. If you're already comfortable entering data in a spreadsheet, you have everything you need to start.

One thing to clarify upfront: AutoFill continues a pattern, Flash Fill transforms data (like splitting first and last names), and AutoComplete suggests a match as you type. Three different tools. We'll touch on all of them so you don't mix them up mid-task.

If you're just getting started with Microsoft Excel more broadly, the Excel for Beginners: Complete Starter Guide is a good place to anchor the bigger picture.

---

Step 1: Use the Fill Handle to Extend a Series (The Core AutoFill Excel Skill)

Drag to Fill a Number or Date Sequence

The fill handle is the small green square that appears at the bottom-right corner of any selected cell or range. Hover over it until your cursor shifts to a thin crosshair, then drag down or across. Excel will extend whatever pattern it detects: numbers, dates, weekdays, months. Type January in one cell, drag the handle, and you'll get February, March, April the rest of the way down. Type 1/1/2026, drag down, and Excel fills consecutive dates automatically.

To autofill numbers in sequence, enter your first two values, say, 10 and 20, select both cells, then drag the fill handle. Excel reads the gap between them and continues: 30, 40, 50. That two-cell selection is doing real work here.

Why AutoFill Copies Instead of Creating a Sequence (and How to Fix It)

Here's the thing: AutoFill's behavior changes completely depending on whether Excel detects a pattern or just a value. A single cell containing 1 will copy, you'll get a column of 1s. Two cells containing 1 and 2 will create a series. Most beginners blame AutoFill for "not working" when the real issue is the seed.

I've seen this question asked dozens of times across MrExcel and the Excel Discord. The answer is always the same: give Excel at least two cells to establish direction and increment. One cell isn't a pattern. It's just a value.

Data pattern recognition is what AutoFill actually runs on, and if you only give it one data point, it has nothing to recognize. Two cells fix it every time.

---

Step 2: Fill Down a Column Without Touching the Mouse

Once you understand the fill handle, the keyboard shortcuts become the faster version of the same logic, and they're almost never mentioned in beginner articles.

1. Select the cell with the value or formula you want to copy.
2. Extend the selection downward to include the cells you want to fill (hold Shift and press the down arrow, or click the last cell in the range while holding Shift).
3. Press Ctrl+D to fill down. For rows, press Ctrl+R to fill right.

This is especially useful when you need to autofill a formula down a column in a large dataset. Select your formula cell, hold Shift, press the down arrow to extend your selection to the last row you need, then Ctrl+D. Done in two seconds.

The Excel ribbon also exposes fill options under Home → Fill, but honestly the keyboard shortcut is faster once it's in your fingers. For a broader look at how Excel basics build into more advanced techniques, that pattern of shortcuts compounding over time is exactly what that guide covers.

---

Step 3: Create a Custom AutoFill List for Repeating Patterns You Use Every Week

This is the half of AutoFill that most beginner tutorials skip entirely.

Excel already knows sequences like months and weekdays. But you can teach it your own: department names, project phases, regional offices, payroll periods. Once it's saved, you type the first item in the list, drag the fill handle, and Excel fills the rest automatically. Same behavior as months. Your data.

In Microsoft 365, here's how to set it up:

1. Go to File → Options → Advanced.
2. Scroll down to the General section and click Edit Custom Lists.
3. Type your list in the box on the right, one item per line.
4. Click Add, then OK.

That's it. Next time you type the first item and drag, Excel recognizes the autofill repeating pattern and extends it. I've used this for client region codes (Columbus, Cincinnati, Cleveland, Dayton) and project phase labels that repeat across every quarterly report. It saves more time than it sounds like it should.

---

Common AutoFill Mistakes (Including the Merged-Cell Problem Most Guides Don't Mention)

The single-cell-versus-two-cell issue we covered in Step 1 is the most common stumble. But there are two others worth knowing before you run into them.

Merged cells stop AutoFill cold. If you're dragging a series down a column and it quietly stops mid-fill, no error, just stops, check for merged cells in the range. Excel can't extend a pattern across a merge boundary. The fix is to unmerge first, fill, then reformat if you need the merge back. This one trips up people who've inherited workbooks from someone else, and it almost never gets mentioned in documentation.

The other mistake is reaching for AutoFill when Flash Fill is actually the right tool. AutoFill continues a series. Flash Fill transforms data: it's what you'd use to pull first names out of a "Last, First" column, or reformat phone numbers. If you're trying to change what's in your cells rather than extend a pattern, AutoFill won't do what you want. The overview of rows, columns, and cells with Flash Fill covers that distinction with clear examples if you want to go deeper on it.

One last note: if you're coming from Google Sheets, the fill handle works similarly, but custom lists and some series behaviors differ. Don't assume the two apps handle data pattern recognition identically. Test before you trust it.

AutoFill notices. Let it.

---