Excel Flash Fill Shortcut Key and How to Use It

In Excel for Microsoft 365 on Windows, the Flash Fill shortcut is Ctrl+E. Enter an example of the result you want beside your source data, then press Ctrl+E to have Excel recognize the pattern and fill the remaining cells.

What Flash Fill Does

Flash Fill creates values by recognizing a pattern in examples you provide. It is especially useful for rearranging, combining, or extracting text without writing a formula. For example, if a column contains full names and you type the first person’s given name in the next column, Excel may infer that you want the given name from each full name below it.

It can also help with tasks such as joining first and last names, separating an email address into parts, or changing how phone numbers are displayed. The feature looks at the sample output and the corresponding source values, then predicts what output fits the pattern. You do not describe the rule in words or choose a special function.

Flash Fill is not the same as AutoFill. AutoFill extends a series, copies a formula, or repeats cell contents; Flash Fill interprets a text pattern. It is also not a formula: the results are ordinary cell values, not calculations that recalculate when source data changes.

How to Use Ctrl+E

Put the source data in one column and the desired results in an adjacent, empty column. For example, with full names in column A starting at A2, use B2 for the first example. Then follow these steps:

Type the result you want for the first row in the cell next to its source value. If A2 contains Maria Chen, you might type Maria in B2.
Move to the next cell below the example, such as B3. Make sure the source data continues in the matching row.
Press Ctrl+E. Excel attempts to fill the rest of the destination column using the example and the source values.
Review the filled values before using them elsewhere. If Excel does not fill the range, use the ribbon command or provide another example.

You can also select the destination range, including the example cell and the blank cells below it, and use the shortcut. Another way to run the feature is Data > Flash Fill on the ribbon. The command is in the Data Tools group in current desktop Excel. On Excel for Mac, use Data > Flash Fill; the keyboard shortcut may depend on the version and keyboard setup, so the ribbon command is a dependable alternative.

Useful Flash Fill Examples

Flash Fill is most effective when the examples make the intended transformation clear and the source values follow a consistent structure. These examples show the kind of task it can recognize:

Extract a first name: Given Maria Chen, type Maria as the sample result. With consistent two-part names, Excel may return the first part for the rows below.
Combine two columns: If A2 contains Maria and B2 contains Chen, type Maria Chen in C2. Excel can infer that the same joining pattern is wanted for subsequent rows.
Make an email address: If a row has a first name in A2 and a surname in B2, type a sample address such as maria.chen@example.com in C2. Flash Fill may infer how to combine the names with punctuation and a domain. Check the output carefully, especially where names contain spaces or accents.
Reformat a phone number: If the source values have consistent digits, type one correctly formatted example next to the original, then ask Flash Fill to fill the remaining rows. It changes the displayed text you create; it does not validate that a number is real or assign country codes correctly.
Extract a code: If each source entry contains a product label followed by a code in a consistent position or format, enter the code from one row as an example. More than one sample may be needed if the code is not in the same position every time.

These are pattern-based suggestions, not guaranteed rules. A sample that works for one row may not explain how to handle exceptions. For example, a name like Ana María López has three parts, while another entry may contain a hyphen. Inspect results for those cases rather than assuming the first few correct rows prove the whole column is right.

When Excel Fills Automatically

You may see Flash Fill suggest results while you are typing examples, without pressing Ctrl+E. If the suggestion matches what you want, accept it by pressing Enter. If no suggestion appears, you can invoke Flash Fill with the shortcut or the Data tab command instead. Automatic suggestions are a convenience; they do not change the basic process of providing an example and checking the result.

On Windows, the automatic behavior can be controlled in Excel’s options. Go to File > Options > Advanced and look for Automatically Flash Fill under the editing options. If that setting is turned off, the manual shortcut and ribbon command are still the ways to try the feature. The wording or availability of settings can vary across Excel versions and platforms.

What Flash Fill Can and Cannot Handle

Flash Fill is a quick way to prepare a one-time set of values, but it does not store a reusable transformation rule. If the source values change later, the completed results generally remain as they were. Run Flash Fill again when appropriate, or use formulas or another data-preparation tool if the output must stay connected to changing source data.

Its predictions can be uncertain when the data is inconsistent, when examples are ambiguous, or when the task has many exceptions. A sample such as extracting the first word may work for ordinary names but fail for titles, middle names, or entries with extra spaces. Flash Fill can also produce plausible-looking but incorrect output; it does not understand the meaning of the data or confirm that an email address, name, or identifier is valid.

For reliable results, keep the source and destination columns separate, provide examples that represent the different patterns in the data, and review the entire output. If the data contains sensitive or important identifiers, compare the filled values against the source before replacing or deleting anything.

Common Problems and Fixes

If Ctrl+E appears to do nothing, first check that the active cell is in the destination column and that at least one example is present beside the source data. The destination range should have room for the results, and the source values should be arranged in matching rows. Then try Data > Flash Fill to see whether the ribbon command produces a result.

No suggestion appears: Type another example that makes the desired pattern clearer, then run Flash Fill again. The data may be too inconsistent for Excel to infer the transformation from a single example.
Only some rows are filled: Check for blank rows, unusual formats, or inconsistent source entries. Add an example that demonstrates how an exception should be handled.
Results are wrong: Undo immediately with Ctrl+Z if you have not made other changes, or correct the destination values manually and rerun the task on a clean range. Always inspect the output before relying on it.
The shortcut does something else: Confirm that you are using desktop Excel and that the intended worksheet cell is active. On a Mac or in a remote desktop session, use the Data tab command if the key combination is intercepted or unavailable.

Flash Fill may also be unavailable in older Excel versions or in environments where the feature is not supported. If the Data tab does not show the command, check the Excel version and update status. Excel for the web may not offer the same shortcut and ribbon behavior as the Windows desktop app; where the command is absent, use a formula or open the workbook in desktop Excel.

Flash Fill Compared with Formulas

Choose Flash Fill when you need a quick, static result and the pattern is easy to demonstrate. Choose a formula when the result should update as source cells change, when you need a rule that can be copied or audited, or when the transformation has precise conditions. For example, a formula can consistently combine two cells with a space between them, while Flash Fill produces a set of fixed outputs based on examples.

For a large, repeated cleanup task, Power Query may be more suitable than either approach. It can record data transformation steps so they can be refreshed on new input. That is useful when the same import or cleanup process recurs; Flash Fill is often faster for a small, one-off rearrangement. The best choice depends on whether you value speed for the current range or repeatability and automatic updates.

Frequently Asked Questions

What is the shortcut for Flash Fill in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+E. You can also select Data > Flash Fill. On Mac, use the Data tab command if the keyboard combination is unavailable in your version or setup.

Why is Ctrl+E not working in Excel?
Make sure you have entered an example beside the source data and selected a cell in the destination column. Try Data > Flash Fill, check that the feature is available in your Excel version, and confirm that automatic Flash Fill has not been disabled if you expected a suggestion while typing.

Does Flash Fill update when the original data changes?
No. Flash Fill places values in cells; it does not create a live link or formula. If the source changes, update the results by running the feature again or use a formula or repeatable data-cleanup process.

Is Flash Fill the same as AutoFill?
No. AutoFill extends series or copies cells and formulas. Flash Fill detects a text transformation from examples, such as extracting a first name or combining two columns.

Can I use Flash Fill on Excel for Mac?
Flash Fill is available in supported desktop versions of Excel for Mac. Use Data > Flash Fill if the Windows shortcut does not work. Keyboard behavior can vary by version, keyboard layout, and system settings.

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.