PlayInfoBox

Home /Utilities /How to Use Flash Fill in Excel

How to Use Flash Fill in Excel

No formulas needed β€” just show Excel one example and let it figure out the pattern.

  1. Type the first result by hand

    Manually type the desired result once in an adjacent column β€” for example, a combined first and last name.

  2. Start typing the second row

    Begin typing a few characters following the same pattern in the row directly below.

  3. Accept the automatic suggestion

    When the remaining cells fill in automatically in gray preview text, press Enter to accept it.

  4. You can also trigger it from the ribbon

    If the suggestion does not appear automatically, click Data β†’ Flash Fill to run it manually.

  5. Why this matters

    Without knowing any complex functions, you can show it a pattern and let it automatically handle tasks like combining names or reformatting dates.

Recognizing patterns without a single formula

Combining a first and last name, or reformatting a phone number, normally takes a formula most people cannot write from memory. Flash Fill only needs one example of what you want, and it figures out the pattern well enough to fill in the rest of the column on its own.

A quick sanity check is worth it

Most consistent patterns are recognized correctly, but irregular or inconsistent source data can produce results you did not intend, so it is worth scanning the filled column before moving on. Keep in mind the result is also a static value, not a live formula, so it will not update automatically if the source data changes later.

Frequently Asked Questions

Does Flash Fill always work correctly?

It recognizes most consistent patterns well, but irregular data can produce unexpected results, so it is worth double-checking the output.

Does the result update automatically like a formula would?

No β€” Flash Fill fills in static values, so the results will not update automatically if the source data changes later.