How to Activate Flash Fill in Excel: Shortcuts and Fixes

How-to basics · Updated November 21, 2026

To activate Flash Fill in Excel for Microsoft 365 on Windows, enter an example of the result in the column beside your source data, then press Ctrl+E. You can also select Data > Flash Fill on the ribbon; Excel detects the pattern and fills the remaining rows.

Activate Flash Fill from the ribbon or keyboard

Flash Fill is a built-in Excel tool for creating values from patterns in nearby data. The quickest way to use it is to type the first result yourself, click the cell containing that example, and press Ctrl+E. Excel then looks at the surrounding rows and proposes matching results in the output column.

  1. Keep the original data in place and choose an empty column for the results.
  2. In the first row of that column, type the result you want. For example, if A2 contains “Jordan Lee,” type “Jordan” in B2 to extract the first name.
  3. Click the example cell, such as B2.
  4. Press Ctrl+E, or select Data > Flash Fill.
  5. Review the results, especially rows containing unusual or inconsistent source text.

You can also find the command under Home > Fill > Flash Fill in the Windows desktop ribbon. If Flash Fill does not appear to run automatically as you type examples, using the ribbon command or shortcut is a useful way to request it directly.

A practical example: splitting full names

Suppose column A contains full names, one per row: “Jordan Lee,” “Priya Shah,” and “Marco Silva.” To extract first names, enter “Jordan” in B2, then press Ctrl+E. Excel may fill B3 and B4 with “Priya” and “Marco.” To extract surnames instead, type “Lee” in C2 and run Flash Fill in that column; Excel may complete “Shah” and “Silva.”

The example works best when your data follows a consistent pattern. If some entries include middle names, titles, or extra spaces, Excel may not infer your intention from one example. Add another example that shows how you want those cases handled, then run Flash Fill again. The examples should represent the actual variations in the list, rather than only its simplest rows.

Flash Fill places its results in cells, so you can review and edit them like other cell contents. It does not create a formula that refers back to the source. If a name in column A changes later, the corresponding filled result in column B generally will not update automatically; you need to run Flash Fill again or use a formula or other method that recalculates.

What Flash Fill does and how it recognizes a pattern

Flash Fill looks for a recognizable relationship between your example and nearby data. It can often extract part of a text value, join text from multiple columns, or change how text is presented. For instance, you might turn “Lee, Jordan” into “Jordan Lee,” combine a first name and surname, or make a list of email addresses from names and a company domain.

It is pattern recognition, not a rule you can inspect or adjust as a formula. Excel uses the example or examples you supply to infer what to put in the other rows. That makes Flash Fill convenient for a one-time cleanup, but it also means you should not assume every generated value is correct. Two different transformations can look plausible from the first row; more examples help make your intended pattern clearer.

Flash Fill works with values already present in the worksheet. It does not retrieve data from a website, identify people, or validate that an email address is real. Its job is to reproduce a pattern in the workbook, not to confirm that the resulting information is accurate.

Tasks Flash Fill is well suited to

Flash Fill is especially handy when the desired transformation is easy to demonstrate but would take time to perform manually across many rows. Common examples include:

  • Splitting first names, surnames, initials, or other text segments into separate columns.
  • Combining values, such as a first name and surname, into a display name.
  • Rearranging a consistent text format, such as changing “Surname, First name” to “First name Surname.”
  • Extracting a repeated piece of text, such as a department code or the part of an email address before the at sign.
  • Creating a consistently formatted text value from existing entries, such as a simple username pattern.

These are examples of pattern-based editing, not guarantees that Excel will interpret every dataset as intended. Text with different separators, missing parts, or multiple possible interpretations can make the pattern ambiguous. Test the results before using them in a report, import, or other consequential task.

Make Flash Fill more reliable

Start with a clean output column and preserve the original data until you have checked the results. This makes it easier to compare what Excel produced with the source and to correct mistakes without losing the starting values. If the workbook is important, save a copy before making broad changes.

Use examples that communicate the rule, particularly when the data varies. For a list containing both “Jordan Lee” and “Jordan A. Lee,” for example, decide whether the desired output should include the middle initial. Enter examples that show that decision. If a few rows use a different format, inspect and correct those rows separately rather than assuming one inferred pattern will handle every exception.

Also check the full output, not just the first few cells. Look for blanks, clipped text, unexpected spaces, or values that were split at the wrong point. Flash Fill may be quick, but reviewing the results is still part of the task.

Fix common Flash Fill problems

If Ctrl+E does nothing, first confirm that you selected a cell containing an example and that there is relevant data nearby. Check that the destination column is available and that the example is next to the source rows. You can also use Data > Flash Fill to invoke the command from the ribbon.

To turn on automatic suggestions in Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, select Automatically Flash Fill, then choose OK. With this setting enabled, Excel may offer to fill the rest of a column after you type an example. You can still run Flash Fill manually when you want to.

If Excel fills values incorrectly, undo the result promptly with Ctrl+Z, provide clearer examples, and run Flash Fill again. A wrong result often means the pattern was ambiguous or the source rows do not share one consistent format. If only a handful of rows are exceptions, it may be safer to correct those entries manually after checking the rest.

If the command is missing or unavailable, check which Excel app and version you are using. Ribbon layouts and feature availability can differ between desktop Excel and Excel for the web. In the web app, try the Data tab if the command is offered; if it is not available in your interface, open the workbook in the desktop app to use the desktop steps.

Flash Fill on Mac and in Excel for the web

In Excel for Mac, look for Data > Flash Fill; ribbon placement can vary with the version and window layout. Keyboard behavior can also depend on the Mac keyboard and Excel build, so the menu command is a dependable alternative if Ctrl+E does not invoke Flash Fill. Do not assume that the Windows shortcut will behave exactly like a Command-key shortcut on a Mac.

Excel for the web has a different interface and may not expose every desktop command in the same place or in every account. If you cannot find Flash Fill in the browser, use Open in Desktop App and follow the Windows or Mac instructions there. The workbook itself can still be saved and opened in the browser after editing.

Flash Fill compared with formulas and Text to Columns

Choose Flash Fill when you want a quick, one-time transformation and can check the output. Choose a formula when results need to respond automatically to changes in the source. Formulas also make the transformation more explicit to another person reviewing the workbook, although the right formula depends on the structure of the text and the Excel version.

Text to Columns, found on the Data tab, is useful when values are separated by a consistent delimiter, such as a comma or a space. It splits data according to a chosen separator rather than learning a custom pattern from examples. For more involved or repeatable data preparation, Power Query can provide a refreshable set of transformation steps. These tools solve related problems, but they are not interchangeable: consider whether you need a quick static result, a formula that recalculates, or a repeatable import-and-clean process.

Frequently Asked Questions

What is the shortcut for Flash Fill in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+E after entering an example in the destination column. On Mac, use Data > Flash Fill if the shortcut does not work in your version.

Why is Flash Fill not working?
Check that you selected the example cell, that related source data is nearby, and that the destination area is available. If automatic suggestions are off, run Data > Flash Fill manually or enable the automatic option in Excel’s Advanced settings.

Does Flash Fill update when the original data changes?
No. Flash Fill produces cell values rather than formulas linked to the source. If source entries change, review and run Flash Fill again, or use a formula or another repeatable method.

Can Flash Fill split a name into first and last names?
Often, yes. Type the desired first name or surname beside a sample full name and run Flash Fill. Names with middle names, multiple surnames, or inconsistent separators may need extra examples or manual review.

How do I turn on automatic Flash Fill?
In Excel for Microsoft 365 on Windows, go to File > Options > Advanced, find Editing options, select Automatically Flash Fill, and click OK. You can still use Ctrl+E to run it manually.

Choose the right method for the job

For a quick cleanup, Flash Fill is easy to activate: type an example, select its cell, and press Ctrl+E, or use Data > Flash Fill. Its main trade-off is that the result is static and based on an inferred pattern. Keep the source data, check the completed column, and use formulas or a repeatable data tool instead when later changes must flow through automatically.

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.