Flash Fill Multiple Cells in Excel: Steps and Limits

How-to basics · Updated November 21, 2026

Yes. In Excel for Microsoft 365 on Windows, Flash Fill can populate many cells in a column by recognizing a pattern in one or two examples: type the desired result beside your source data, then press Ctrl+E or choose Data > Flash Fill. To fill several different columns, run Flash Fill separately for each output column; it is not a single command that creates a whole table of unrelated results.

What Flash Fill does

Flash Fill detects a transformation you demonstrate with sample values and applies what it infers to the remaining rows. It is useful for rearranging or extracting text, combining pieces of text, and changing the appearance of entries without writing a formula. For example, if a column contains full names and you type a first name beside the first full name, Excel may infer that you want first names for the other rows too.

Unlike a formula, Flash Fill writes ordinary values into cells. It does not leave behind a calculation that refers to the original data. That makes it convenient for preparing a one-time list to export or share, but it also means later changes to the source will not automatically update the filled results.

How to fill multiple cells in one column

Arrange the source data and the blank output column next to each other, with each source record on the same row as its intended result. Use the following method in Excel desktop for Windows:

  1. Enter a heading for the new column if your table uses headings.
  2. In the first output cell, type the result you want for the first source row. For a more reliable pattern, type the desired result for a second row as well.
  3. Click the next empty cell below your examples in the output column. Press Ctrl+E, or select Data > Flash Fill.
  4. Review the filled values before using or sharing them. If Excel fills only part of the range, select the remaining destination cells and run Flash Fill again, or add clearer examples.

For instance, suppose A2 contains Jordan Lee and A3 contains Priya Shah, and you want first names in column B. Enter Jordan in B2 and Priya in B3, then invoke Flash Fill from B4. Excel can fill the remaining rows in column B with the corresponding first names. The exact result depends on whether the examples make the intended pattern clear.

Filling several output columns

Flash Fill works best as a separate operation for each output column. Imagine a list of full names in column A and a goal of extracting first names into B and surnames into C. Demonstrate the first-name pattern in B, run Flash Fill down that column, then demonstrate the surname pattern in C and run it there. Check that the source and output rows remain aligned.

You can also use it for different transformations on the same source. A product code such as AB-4821 might be copied into one output column as AB and another as 4821, provided you give examples that show each intended result. Excel does not treat a selection of several adjacent output columns as a request to infer a different transformation for every column. Select or work in one destination column at a time to keep the operation clear.

When filling a long list, make sure the output range has room for all records and that the neighboring source column is populated consistently. Blank rows, subtotals, or unrelated data near the range can make it less obvious where the pattern should stop. A quick review at the top, middle, and bottom of the filled results can catch a pattern that went wrong partway through.

Examples Flash Fill can recognize

Flash Fill is especially handy when the task is easy to describe with examples but tedious to repeat manually. Common uses include:

  • Separating first names, surnames, initials, or parts of an identifier into a new column.
  • Combining a city and state into a label, or adding punctuation and spacing to text.
  • Changing text such as a customer code into a consistent display style.
  • Extracting a repeated prefix or suffix from codes, filenames, or descriptions.

For example, if cells contain codes like INV-2026-014, an example such as 2026 may suggest that you want the middle section. If you instead want the final number with leading zeroes preserved, show that exact result in your example. The displayed appearance matters: typing 14 rather than 014 may communicate a different pattern, and Excel may treat codes with leading zeroes as text or numbers depending on how they were entered.

Why Flash Fill may give the wrong result

Flash Fill makes an inference, not a guarantee. A pattern that appears obvious to a person may be ambiguous to Excel, particularly when names have different structures, codes use inconsistent separators, or the sample rows do not represent the exceptions in the list. If it produces an unexpected result, undo it immediately with Ctrl+Z, then provide more representative examples and try again.

  • Give two or more examples. One example can be enough for a simple pattern, but additional examples help distinguish alternatives, such as extracting a surname versus taking the last word.
  • Include exceptions in your review. Compound surnames, middle names, suffixes, and inconsistent spacing can defeat a pattern that works for ordinary rows.
  • Check for blank or irregular rows. Empty cells and records that use a different format may interrupt or confuse the detected pattern.
  • Confirm the correct destination column is active. Flash Fill uses nearby data and the examples you supply; placing the result column somewhere unrelated can make the relationship harder to detect.
  • Inspect the full output. Do not assume that a successful fill means every row is correct, especially when the list contains mixed formats.

If Excel does not start filling automatically as you type, use Data > Flash Fill or the shortcut instead. On Windows, the automatic behavior can be enabled or disabled at File > Options > Advanced, under Editing options, by changing Automatically Flash Fill. The option controls whether Excel offers or performs Flash Fill as you enter examples; the manual command remains available in desktop Excel.

Flash Fill versus formulas

Choose Flash Fill when you need a quick, fixed set of results and can verify that the inferred pattern is correct. Choose a formula when the result should respond to changes in the source, when the rule must be repeated reliably, or when the workbook needs a transparent, auditable calculation. A formula remains connected to its inputs; Flash Fill’s output does not.

For example, if you Flash Fill first names and then correct a misspelled full name in the source column, the already-filled first name generally stays as it was. You must run Flash Fill again or correct the output yourself. With a formula-based approach, a properly constructed formula can recalculate from the edited source. Formulas take more setup and can require more care with unusual text, so Flash Fill is often faster for a small, one-off cleanup.

There is also a practical difference when handing off a workbook. Flash Fill results are values that are easy to copy or export, but another user cannot inspect a formula to see how each result was produced. If repeatability matters, document the transformation or keep the original data and use a formula or another repeatable data-cleaning method.

Excel versions and keyboard access

In Excel for Microsoft 365 on Windows, the ribbon command is Data > Flash Fill and the keyboard shortcut is Ctrl+E. Excel desktop for Mac also provides Flash Fill; use Data > Flash Fill if available, and the shortcut is commonly Control+E. Mac keyboard settings and versions can affect shortcut behavior, so the ribbon command is the straightforward fallback.

Flash Fill is not available in the same way in Excel for the web. If you are working in a browser and do not see the command, open the workbook in the Excel desktop app to use Flash Fill. Otherwise, use an appropriate formula or perform the transformation another way. Menu availability can vary by edition and update, so use the desktop ribbon as the first check.

Frequently Asked Questions

Can Flash Fill fill an entire column at once?
It can fill the remaining cells in a column when Excel recognizes your examples and the adjacent source data. Provide one or two results, then use Data > Flash Fill or Ctrl+E. Review the results because the feature may infer an incorrect pattern.

Can I Flash Fill two columns at the same time?
For different results in different columns, run Flash Fill separately for each output column. Demonstrate the pattern in one column, fill it, then repeat for the next. A single run is not a reliable way to generate multiple distinct fields across a table.

Does Flash Fill update when the source data changes?
No. Flash Fill creates fixed values rather than live formulas. If you edit the source later, run Flash Fill again or update the affected output cells manually.

Why does Ctrl+E not work?
Check that you are using desktop Excel, that the destination cell or range is selected, and that the examples and source data are arranged on matching rows. You can also use Data > Flash Fill. Excel for the web may not provide the feature.

Can Flash Fill split text at a delimiter every time?
It can often infer a split from examples, but it does not enforce a formal delimiter rule. If some rows use different separators or formats, verify the results carefully. For repeatable handling of varied data, a formula or a structured data-cleaning method may be more suitable.

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.