Excel Flash Fill Shortcut: How It Works and When to Use It

In Excel for Microsoft 365 on Windows, the Flash Fill keyboard shortcut is Ctrl+E. Enter one or two examples of the transformation you want in a neighboring column, select the cells to fill, and press Ctrl+E; Excel detects the pattern and supplies matching values.

What the Flash Fill shortcut does

Flash Fill recognizes a pattern in your examples and uses it to create results from nearby data. It is especially useful for reorganizing text, combining parts of a name, extracting an initial, or formatting values for display. You provide examples rather than writing a formula or setting up a rule.

For example, if column A contains full names such as Jordan Lee and Priya Shah, you could type Jordan in B2 and Priya in B3. Flash Fill may infer that you want the first name from each full name and complete the rest of column B. It can also combine information: if first and last names are in separate columns, type a complete name in a third column and ask Flash Fill to continue the pattern.

The result is ordinary cell content, not a live formula. That distinction matters: if the source name changes later, the filled result generally will not update automatically. Flash Fill is a quick data-preparation tool, not a permanent relationship between source and output.

How to use Ctrl+E step by step

Put the source data in a column, with a header if appropriate. Keep the examples you want Excel to inspect next to that source column.
In the adjacent output column, type the result you want for the first source row. For example, type a first name beside a full name.
Move to the next output cell and type another example if the intended pattern might be unclear. Different or irregular examples help Excel distinguish the rule you mean.
Select the first blank output cell below your examples, or select the range you want filled, and press Ctrl+E.
Inspect the results before relying on them. Correct an incorrect example or add another clear example, then run Flash Fill again.

You can also start Flash Fill from the ribbon: choose Data > Flash Fill. In Excel for Windows, this is on the Data tab. Depending on your ribbon layout, the command appears in the Data Tools group. If you select a range first, Excel attempts to fill that range; if you are positioned in the output column, it may fill down based on the nearby data and examples.

Patterns Flash Fill can recognize

Flash Fill is most effective when the transformation is consistent and easy to infer from a few rows. It does not require that every source entry be identical in length, but inconsistent punctuation, missing parts, or several plausible interpretations can make its guess unreliable.

Extracting text: Turn Morgan Chen into Morgan, or take initials such as MC from names.
Combining text: Join a first-name column and a last-name column into a display name.
Reformatting text: Change a phone number’s displayed punctuation, or reshape a code into a consistent layout.
Separating components: Pull a city or other recognizable component from a consistently structured text field.
Changing capitalization: Create a differently capitalized version of text when examples make the desired treatment clear.

These are pattern examples, not guarantees. Flash Fill is not a general-purpose parser and does not understand the meaning of every field. If a column mixes formats—for instance, names with middle initials, suffixes, and single-word entries—provide enough representative examples and check every result.

A concrete example: extracting first names

Suppose A1 is a header called Full name, and A2:A5 contains Jordan Lee, Priya Shah, Morgan Chen, and Alex Rivera. Put First name in B1 and type Jordan in B2. In B3, type Priya. These two examples point to the first-name pattern. Select B4, or the output range you want to populate, and press Ctrl+E. Excel should return Morgan and Alex for the remaining rows.

Now consider a less consistent list: Jordan Lee, Priya Shah, Morgan A. Chen, and Alex Rivera Jr. An example that works for the first two rows may not tell Excel whether to include a middle initial or suffix. Add examples that show how those cases should be treated, and inspect all results. If the desired rule is complicated or needs to remain connected to changing source data, use a formula or a more controlled data-cleaning method instead.

Flash Fill versus formulas and Text to Columns

Flash Fill, formulas, and Text to Columns can all help reshape data, but they solve different problems. Choosing the right tool depends on whether you need a fast one-time result, a result that recalculates, or a consistent split based on a known delimiter.

Choose Flash Fill for a quick transformation that is easy to demonstrate with examples, especially when writing a formula would take longer than checking the result.
Choose a formula when output must update as source cells change, when the rule must be explicit, or when the workbook will be reused. Formulas are also easier to audit because their logic is visible in the cell.
Choose Text to Columns when a column has a predictable separator, such as a comma or a space, and you want Excel to split it into separate columns using a defined delimiter.

Flash Fill is not the same as AutoFill. AutoFill extends a series, copies formulas, or repeats values based on selected cells and the fill handle. Flash Fill interprets an example of a text transformation. Neither feature should be confused with a formula: Flash Fill writes values, while a formula calculates a result from references or other inputs.

Common problems and how to fix them

If Ctrl+E appears to do nothing, first check that you are using the desktop version of Excel and that the output column is beside the source data. Confirm that there is at least one clear example in the output column. A header alone is not a transformation example. You can also try Data > Flash Fill to confirm whether the command is available in your version.

Excel fills the wrong pattern: Undo the result if necessary, then replace an ambiguous example with one that makes your intended output unmistakable. Add examples from unusual rows, not just the simplest entries.
Only part of the column is filled: Check for blank rows, breaks in the data, or a selected range that ends too soon. Select the intended output cells or run Flash Fill again from the appropriate starting cell.
Results look right but contain errors: Review rows with different punctuation, extra spaces, missing values, or additional name parts. Flash Fill does not validate that its interpretation matches your business rule.
New source rows are not transformed: Flash Fill does not work like a formula that automatically calculates for future rows. Run it again for new data, or use a formula or another repeatable workflow.

Excel can automatically suggest or apply Flash Fill when it detects a pattern as you type. If that behavior is turned off, the manual shortcut or ribbon command can still be used when available. In Windows desktop Excel, the setting is under File > Options > Advanced, in the Editing options, as Automatically Flash Fill. It may be helpful to leave automatic suggestions off if you prefer to choose when a pattern is applied.

Windows, Mac, and Excel for the web

This guide is written for Microsoft 365 Excel on Windows, where Ctrl+E is the direct shortcut. In Excel for Mac, try Control+E if your keyboard setup supports it; Mac shortcuts can vary with the application version and keyboard configuration. The reliable ribbon route in the desktop app is Data > Flash Fill. If the shortcut does not work, use the ribbon command rather than assuming the feature is unavailable.

Excel for the web has a more limited feature set than the desktop application, and Flash Fill may not be available there. If you cannot find Data > Flash Fill in the browser, open the workbook in desktop Excel and use the command there. Availability and interface details can change as Microsoft updates Excel, so the visible ribbon command is a useful check for the version you are using.

How to check and maintain Flash Fill results

Treat Flash Fill output as a suggested transformation that deserves review, especially in a large list or one with inconsistent entries. Check the first few rows, the last few rows, and examples that look unusual. Sorting or filtering the source by length, punctuation, or blank values can help expose cases that a small sample would miss. For important data, compare the output against the original source before sharing or importing it elsewhere.

Because Flash Fill writes values, it will not automatically revise them when inputs change. If you need an output column to stay synchronized, keep a formula-based solution or repeat the Flash Fill step after updating the data. For a one-time cleanup, consider preserving a copy of the original column until you have verified the transformed values. This gives you a straightforward way to compare the result and recover source information if the pattern was applied incorrectly.

Frequently Asked Questions

What is the keyboard shortcut for Flash Fill in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+E. You can also choose Data > Flash Fill from the ribbon.

Why is Ctrl+E not working in Excel?
Make sure you are in desktop Excel, have a clear example in the output column, and are working next to the source data. If the shortcut still fails, try Data > Flash Fill; the command may not be available in the version or interface you are using.

Does Flash Fill update when the original data changes?
No. Flash Fill produces cell values rather than live formulas, so those values generally remain unchanged when the source changes. Run Flash Fill again or use a formula if you need results to recalculate.

Is Flash Fill the same as AutoFill?
No. AutoFill extends a sequence or copies values and formulas. Flash Fill detects a text pattern from examples and creates corresponding values.

Can I use Flash Fill in Excel for Mac?
Use Data > Flash Fill in the Mac desktop app. You can try Control+E as the shortcut, but keyboard behavior can depend on the version and configuration.

Can I use Flash Fill in Excel for the web?
Flash Fill may not be available in the browser version. If the command is missing, open the workbook in desktop Excel and use Data > Flash Fill.

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.