Excel Autofill and Flash Fill: How Each Feature Works

How-to basics · Updated November 18, 2026

Excel Autofill extends values, dates, formatting, or formulas from a selection; Flash Fill detects a text pattern from examples and fills a new column with matching results. Use Autofill for sequences and formula copying, and Flash Fill for one-time text transformations such as splitting names or extracting codes.

What Autofill and Flash Fill Have in Common

Both features help you complete repetitive spreadsheet work without entering every result by hand, but they solve different problems. Autofill continues or copies information based on selected cells and the direction you drag. Flash Fill looks at nearby data and examples you have typed, then predicts the transformation you want. Neither feature is a general substitute for checking the resulting data.

In Microsoft Excel for Microsoft 365 on Windows, Autofill is usually accessed by dragging the small square at the lower-right corner of a selected cell or range. Flash Fill can be started from Data > Flash Fill or with Ctrl+E. On Mac, use the Data tab’s Flash Fill command if it is available in your version; keyboard shortcuts can differ. Excel for the web does not provide the same Flash Fill workflow as the desktop app, so open the workbook in desktop Excel if you need that command.

How Autofill Works

The small square at the lower-right corner of the active selection is called the fill handle. Drag it down, up, left, or right to extend the selected content. Excel uses the starting cells to decide whether to copy entries, continue a recognizable series, or extend formulas. The result depends on what you selected, so a single starting value can behave differently from a pair of examples.

  • Copying a value: Dragging a single cell containing Monday may repeat Monday. Selecting Monday and Tuesday first gives Excel evidence to continue the weekday sequence.
  • Continuing numbers: Dragging one cell containing 5 commonly copies 5. Select cells containing 5 and 10, then drag to continue the step of five: 15, 20, and so on.
  • Extending dates: A date can be copied or continued by day, depending on the selection and the option chosen after filling. Excel recognizes many date and month patterns.
  • Copying formulas: A formula is copied with relative references adjusted for the destination. Absolute references marked with dollar signs stay fixed.
  • Extending formatting: Autofill can carry cell formatting as well as content. The Auto Fill Options button lets you choose a different fill behavior after a drag.

For example, if B2 contains a formula that adds the values in A2 and A3, dragging the fill handle down typically adjusts the references in each new row. This makes Autofill useful for repeating calculations across a table, but it is worth inspecting the first few filled formulas to confirm that the references are appropriate.

Using Autofill Step by Step

To fill a range, enter the starting value, formula, or pattern in a cell. Select that cell, or select the cells that establish a pattern, and position the pointer over the fill handle. When the pointer changes to a small black cross, drag across the destination cells. Release the mouse button, then review the result and use the Auto Fill Options button if Excel chose the wrong behavior.

For a numbered sequence, enter at least two starting values when you want a specific interval. For instance, enter 100 in A2 and 125 in A3, select both cells, and drag downward. Excel can infer increments of 25. If you drag only A2, Excel may repeat 100 instead. Another option is to select a starting cell and use Home > Fill > Series to set a step value and a stopping value. The Series dialog is useful when a sequence must end at a precise number or follow a specified interval.

Autofill is not limited to dragging. In Windows Excel, select the source cell and the cells below it, then press Ctrl+D to fill down; Ctrl+R fills right. On Mac, the corresponding shortcuts are generally Command+D and Command+R. Menu commands are a useful alternative when a laptop touchpad or a small selection makes dragging awkward. Shortcut availability can depend on the Excel version and keyboard settings.

How Flash Fill Works

Flash Fill recognizes a transformation from examples you provide, usually by comparing a new column with adjacent source data. Suppose column A contains full names such as Jordan Lee and Priya Shah. Type Jordan in B2, the desired first-name result, and begin entering the next result. Excel may show a preview of the remaining first names. If the preview is correct, press Enter to accept it. You can also select the destination cells and choose Data > Flash Fill, or use Ctrl+E on Windows.

Flash Fill is particularly handy for text that follows a visible pattern. It can often combine or separate pieces of text, change capitalization, extract a portion of an entry, or reformat values. For example, if a column contains email addresses and you enter the part before the @ symbol in a neighboring column, Flash Fill may infer that you want the usernames. It can also turn entries such as 555-010-2040 into a consistent presentation when your examples make the intended output clear.

Unlike a formula, a Flash Fill result is a value, not a live calculation tied to the source cell. If the original name or address changes later, the generated result does not reliably recalculate to match it. Run Flash Fill again or use a formula or other repeatable transformation when the source data will change and the output must stay current.

Choosing the Right Feature

Choose based on what you want Excel to infer. Autofill is the better fit when you are extending a series, copying formulas, repeating content, or carrying formatting across cells. Flash Fill is the better fit when you can describe a text transformation by giving examples but do not need a formula-based result that updates later.

  • Use Autofill for dates, weekday sequences, numbered intervals, repeated labels, and formulas copied down a table.
  • Use Flash Fill to split a full name into parts, extract a username from an email address, rearrange text, or standardize a simple text pattern.
  • Use a formula, Power Query, or another repeatable data-cleaning method when results need to update as source values change or the transformation is complex.

These tools can also work together. You might use Flash Fill to create a one-time column of first names, then use Autofill to copy a formula that counts or categorizes the resulting entries. The important distinction is that Autofill extends cell content according to a pattern in the selected cells, while Flash Fill predicts a transformation from examples.

Examples and Important Limits

Consider a list of product codes such as NW-4821 and SE-1905. If the goal is to extract the two-letter region, type NW in the adjacent column and let Flash Fill infer the pattern from further examples. This can save time, but it is not a rule engine: if codes have inconsistent lengths, extra hyphens, or exceptions, the preview may be wrong. Inspect unusual rows rather than assuming that a plausible-looking output is correct.

For a weekly schedule, Autofill is usually more dependable. Enter two dates a week apart, select both, and drag to continue weekly dates. If you want consecutive calendar days instead, use two consecutive dates or adjust the fill options. When the filled dates skip weekends or repeat unexpectedly, check what starting pattern you selected and the Auto Fill Options choices.

Flash Fill is not the same as splitting data at a fixed delimiter. It makes a prediction from examples, so ambiguous input can lead to inconsistent results. Autofill also cannot know the meaning of a sequence: if numbers happen to look like a pattern but are identifiers, continuing them may create entries that were never valid. In both cases, the feature can produce syntactically neat but incorrect data.

Common Problems and Fixes

If the fill handle is missing, check whether the feature is enabled in Excel’s options. In Windows desktop Excel, open File > Options > Advanced and look for the setting to enable the fill handle and cell drag-and-drop. If dragging copies a number instead of continuing a sequence, provide two or more example values, or use the Auto Fill Options button to select a series-related choice. If formulas repeat the same result, inspect their cell references and check whether the references were made absolute unintentionally.

If Flash Fill does not offer a preview, make sure the example is in a column next to the source data and that it clearly demonstrates the intended result. Try entering a second example, then choose Data > Flash Fill. Also confirm that you are using desktop Excel with Flash Fill available; the web version may not expose the same command. When Excel fills only some rows or applies the wrong pattern, undo the fill, add clearer examples, and run it again.

Formatting can create another surprise. Autofill may carry the source cell’s number format, color, or borders along with the value. If that is not wanted, use the Auto Fill Options button and choose a content-only option where available, or format the destination range afterward. For Flash Fill, make sure the destination column is empty or that you have selected the intended cells, since filling over existing entries can replace data.

Checking Results and Handling Sensitive Data

Before relying on either feature, compare a sample of the results against the source. Check the first and last filled rows, records with unusual punctuation or spacing, and entries that do not follow the main pattern. For Flash Fill, look especially for names with multiple parts, suffixes, initials, inconsistent separators, or blank source cells. A pattern that works for most rows may fail on exceptions.

Both features operate within the workbook; using them does not require sending the selected cells to a separate service. Still, ordinary workbook privacy practices matter: be careful when sharing files that contain personal or confidential information, and remove unwanted source or helper columns before distributing a copy. If the transformation must be explainable and repeatable for other people, a clearly labeled formula or documented Power Query step may be easier to audit than a one-time Flash Fill result.

Frequently Asked Questions

What is the difference between Autofill and Flash Fill in Excel?
Autofill copies or extends cell contents, formulas, formatting, and recognizable series. Flash Fill detects a text pattern from examples and writes the predicted results as values.

What is the shortcut for Flash Fill in Excel?
In Windows desktop Excel, select the destination cells and press Ctrl+E. You can also use Data > Flash Fill. On Mac, use the Data tab command if available, since keyboard shortcuts can differ.

Does Flash Fill update when the original data changes?
No. Flash Fill writes results as values rather than maintaining a live relationship with the source. Re-run it after source changes, or use a formula or another repeatable method.

Why does Autofill repeat a number instead of counting up?
A single number does not always tell Excel the interval you intend. Enter two starting numbers that show the pattern, select both, and drag the fill handle, or use Home > Fill > Series to define the interval.

Can I use Flash Fill in Excel for the web?
The desktop app is the dependable choice for the Flash Fill command and its Ctrl+E shortcut. If you do not see Flash Fill in the web version, open the workbook in desktop Excel or use a formula-based alternative.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.