Flash Fill Excel: How to Use It (With Examples)

Flash Fill Excel — its pattern-matching autofill — completes a column by learning from one or two examples you type. Unlike a formula, it needs no syntax: you show it the result you want, press a shortcut, and it copies the logic down the whole column. This guide covers how Flash Fill in Excel works, the keyboard shortcut, the jobs it does best, the limits that trip people up, and a no-upload way to reshape a CSV column.

What Flash Fill does in Excel

Flash Fill watches what you type and completes a column when it recognises a repeatable transformation. Microsoft describes it plainly: "Flash Fill automatically fills your data when it senses a pattern" (Microsoft, Using Flash Fill in Excel). You give it a worked example next to the source data, and it infers the rule and applies it to every remaining row.

The key difference from a formula is that you never write the logic. To pull a first name out of a full-name column, you would normally reach for LEFT and FIND and nest them. With Flash Fill you type Jane next to Jane Doe, and Excel works out that you want the text before the first space. It handles splitting, joining, changing case, inserting characters, and extracting fragments — all from the example, not from a rule you spell out.

There is one condition that matters: the result column has to sit directly beside the data Excel should read. Flash Fill looks at the adjacent column to learn the pattern, so an example typed three columns away with blanks in between gives it nothing to work from. Keep the source and the target next to each other and the feature has what it needs.

How to use Flash Fill with the keyboard shortcut

The fastest way to trigger Flash Fill is the Ctrl+E shortcut. Here is the full sequence on a name column:

1. Put your source data in column A, for example Jane Doe in A2 and more full names below it.
2. Click the first cell of the empty column next to it, B2.
3. Type the result you want for that one row: Jane.
4. Move down to B3 and press Ctrl+E.
5. Excel previews the rest of the column in light grey. Press Enter to accept it.

If the preview does not appear, type a second example in B3 before pressing Ctrl+E — two rows remove any ambiguity about the pattern. You can also run the feature from the ribbon at Data > Flash Fill if you prefer menus to shortcuts. And if nothing happens at all, the feature may be switched off: turn it back on under File > Options > Advanced by ticking Automatically Flash Fill, then try the shortcut again.

Flash Fill fits into a wider routine for cleaning up a messy spreadsheet alongside trimming spaces, removing blank rows, and fixing casing. It is the tool you reach for when the fix is a text transformation you can demonstrate faster than you can describe.

The jobs Flash Fill handles best

Flash Fill shines on repetitive text reshaping where the pattern is obvious from one row. Four jobs come up constantly:

• Splitting a column. Pull first and last names into separate columns, or lift the city out of a full address. Type the piece you want and Excel extracts it down the list.
• Combining columns. Join a first-name column and a last-name column into a single display name, or stitch a code and a label together with a dash between them.
• Reformatting values. Turn [email protected] into Jane Doe, add parentheses around area codes, or rewrite 2026-07-24 as 24 Jul 2026.
• Changing case. Convert a shouting JANE DOE column to Jane Doe without the PROPER function.

For the combine case, Excel's own guidance points to a formula alternative worth knowing: you can "combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function" (Microsoft, Combine text from two or more cells). Flash Fill gets you the same result without the syntax, which is why it is faster for a one-off. When you need the merge to stay live as the source changes, though, the formula — or a dedicated tool — wins. The same trade-off applies when you join two columns into one as a repeatable step rather than a quick fill.

Where Flash Fill falls short

Flash Fill has two limits that catch people out, and both come from the same root: it writes static values, not formulas. First, the output does not update. Once you accept the preview, the filled cells hold plain text. Edit a source value afterwards and the Flash Fill result stays as it was — you have to run the fill again over those rows. If you need a column that tracks its source, a formula such as TEXTSPLIT, LEFT, or CONCAT is the right choice.

Second, it only guesses as well as your example lets it. Feed it a clean, consistent pattern and it is reliable. Feed it names where some rows have middle initials, some are Last, First, and some are compound surnames like van der Berg, and the pattern Excel infers from row two can be wrong by row two hundred — silently. Always scroll the filled column and spot-check the awkward rows before you trust it.

This is where a purpose-built splitter beats a guessed pattern. Excel's structured alternative for a clean delimiter split is the Text to Columns wizard, where you "select Delimited" and then pick "the Delimiters for your data. For example, Comma and Space" (Microsoft, Convert Text to Columns Wizard). Text to Columns is predictable but blunt — it splits on a fixed character and always writes to the right. For names specifically, a tool that understands first, middle, and last parts handles the edge cases Flash Fill and a naive delimiter split both mangle. Sigmera's full-name splitter is built for exactly that, and its column-join tool covers the reverse.

Flash Fill a CSV in the browser, nothing uploaded

If your data is a CSV headed for a CRM or another import, you may not want to open Excel at all. Opening a CSV in Excel to run Flash Fill risks a second problem: Excel can drop leading zeros from postal codes, reformat long numbers, or mangle dates on the way in and out. When the source is a plain CSV, it is cleaner to reshape the column in the file directly.

A browser tool does the same split, combine, and reformat work without the round trip. Sigmera runs entirely in your browser, so a file full of customer names, emails, or phone numbers is never sent to a server and stays GDPR-safe by default. Split a name column, join a city and country into one field, or standardise values with the in-browser cleaning tools — previewing every change before you download. Every plan includes every tool with no row or file-size cap; you can preview unlimited cleanups free and only a per-account download counter ticks, so the file itself never leaves the device (see pricing for the download tiers).

The rule of thumb is simple. Reach for Flash Fill when you are already in Excel and the fix is a quick, one-off pattern you can demonstrate. Reach for a formula when the result must stay in sync with its source. And reach for a browser cleaner when the data is a CSV you would rather not upload — same reshaping, no server, nothing to undo.