Ctrl+E in Excel: Flash Fill Shortcut and How It Works

In Excel for Microsoft 365 on Windows, Ctrl+E runs Flash Fill: it detects a pattern in your examples and fills the rest of a column to match. Enter one or two examples in the desired format, select the cells to fill if needed, and press Ctrl+E; Excel supplies results without creating a formula.

What Ctrl+E Does in Excel

Ctrl+E is the keyboard shortcut for Flash Fill in Excel. Flash Fill looks at nearby data and the example or examples you provide, then tries to infer the transformation you want. It is useful when you need to extract, combine, or reformat text in a list, such as turning full names into first names or joining a city and state into one label.

The shortcut is context-specific. In Excel, Ctrl+E means Flash Fill; the same keys can do something different in another program. It is also not the same as a formula or a general fill-down command. Excel is recognizing a pattern in sample data and writing the resulting entries into cells.

Flash Fill is available in modern desktop versions of Excel, including Microsoft 365. If you are following instructions written for another spreadsheet program, do not assume its Ctrl+E behavior is the same.

How to Use Ctrl+E Step by Step

Work in a spare column so the original data stays unchanged. For example, if full names are in column A and you want first names in column B, provide a sample in B2. Then use Flash Fill to complete the intended range.

Put the source data in a consistent column, with a header if that helps you identify it.
In the adjacent destination column, type the result you want for the first source row. For example, if A2 contains Maya Chen, type Maya in B2.
Start the next result in B3. Excel may display a preview of the rest of the column. If the preview matches your intention, press Enter to accept it.
If there is no preview, finish entering an example or two, select the destination cells you want filled, and press Ctrl+E.
Review the output, especially the first and last rows and any unusual entries.

You can also run the command from the ribbon: choose Data > Flash Fill. That is helpful if the shortcut is unavailable, if you forget it, or if you want to confirm which command you are using. Depending on the layout and selection, Excel may fill the destination range based on the neighboring source column and the examples already entered.

Examples of Useful Flash Fill Patterns

Flash Fill is best for straightforward transformations that are easy to demonstrate. The sample values matter: they show Excel the output format, so use examples that reflect the rule you actually want rather than examples that happen to fit only the first few rows.

Extracting a first name: from Maya Chen, enter Maya. If names include middle names, initials, or inconsistent spacing, check those cases carefully.
Combining fields: if one column contains a first name and another contains a surname, enter a combined example such as Maya Chen. You can include a space, comma, or other separator in the sample.
Reformatting an identifier: you might show how a code such as AB1234 should appear as AB-1234. Inspect all codes because different lengths or prefixes may make the intended pattern ambiguous.
Changing letter case: demonstrate the capitalization you want, such as converting a name to uppercase or using a consistent name format.
Extracting part of an address or label: a sample can show a city, department, or other recognizable portion, but mixed formats can lead to inconsistent results.

Dates deserve extra attention. A displayed date can be stored as a date value, while a pattern that looks like text may produce text. Regional date conventions can also make a string such as 03/04/2026 unclear. Check both the cell value and its display before relying on filled dates in later calculations.

What Flash Fill Changes—and What It Does Not

Flash Fill writes results into cells; it does not build a formula that keeps referring to the source data. If you change a source name later, the corresponding Flash Fill result usually does not update automatically. Run Flash Fill again or edit the output if the source list changes.

That behavior can be convenient when you need a one-time cleanup or a fixed export. It is less suitable for a workbook that must recalculate whenever someone edits the original data. In that situation, a formula is often a better fit. Flash Fill also does not validate whether the transformation is logically correct. It can produce plausible-looking results from an incorrect interpretation, so the user still needs to review the output.

Keep a copy of the original column until you have checked the results. This is especially important when the source contains exceptions, such as compound surnames, blank rows, different separators, or IDs with varying formats.

When Flash Fill Is a Good Choice

Use Flash Fill when the task is a simple, visible pattern and you want a quick set of fixed results. It can save time on a manually prepared list without requiring you to learn a formula. It is particularly practical for one-off preparation of names, labels, and text fields.

Choose another method when the task needs repeatable logic, must update as source data changes, or depends on precise rules. A formula is easier to audit and recalculate. Power Query is often more appropriate for a repeatable import-and-clean process. Text to Columns is useful when you want to split a whole column using a clear delimiter, such as a comma, rather than ask Excel to infer a pattern.

Consider the importance of the result, too. For casual formatting, a quick review may be enough. For identifiers, customer records, or data used in a report, compare the output against the original and investigate every unusual case instead of accepting the preview blindly.

Common Problems and How to Fix Them

Nothing happens: confirm that you entered a sample in the destination column and that the relevant source data is nearby. Try selecting the cells to fill and using Data > Flash Fill. A preview may not appear if Excel cannot identify a clear pattern.
The results are wrong: add another example that shows how to handle the exception, then run Flash Fill again. If the source rows follow several different conventions, separate them into consistent groups or use a more explicit method.
Some rows stay blank or look different: check for blank source cells, extra spaces, inconsistent punctuation, or a different number of words. These variations can make an otherwise obvious pattern unclear.
Leading zeros disappear: Excel may interpret a result as a number rather than a text identifier. Set the destination cells to Text before filling when the zeros are meaningful, and verify the result. Do not treat a code as a number if its formatting is part of its identity.
Flash Fill starts automatically when you type: on Windows, check File > Options > Advanced and the Automatically Flash Fill option under Editing options. Turning off automatic suggestions is different from choosing the Flash Fill command yourself.

When troubleshooting, try a small section of the data first. If the pattern works for that section but not the full list, the issue is often an exception in the source rather than the shortcut itself.

Flash Fill Compared With Formulas and Text to Columns

These tools can produce similar-looking results but work differently. Flash Fill infers what to write from examples. A formula states a rule in a cell and can recalculate when its references change. Text to Columns follows explicit parsing choices, such as splitting at a delimiter or at fixed character positions.

For example, splitting a list of consistently formatted full names at a space may seem easy, but names do not always have exactly two parts. Flash Fill may infer the desired first-name output from examples, but it can still misread exceptions. A formula or a deliberate cleanup process may be safer when every row must follow a defined rule.

There is no requirement to use Flash Fill just because Ctrl+E is available. Pick the method that matches the job: examples for a fast one-time transformation, formulas for live results, and structured import tools for repeatable data preparation.

Using the Shortcut on Mac and in Excel for the Web

In Excel for Mac, the Flash Fill shortcut is generally Control+E, using the Control key rather than Command. Keyboard behavior can depend on the Excel version and system settings, so if the shortcut does not run, use Data > Flash Fill when that command is available in your Excel interface.

Excel for the web and desktop Excel do not always expose the same commands or keyboard behavior. If Ctrl+E does not work in a browser, check the Data tab for Flash Fill or open the workbook in the desktop app. The ribbon command is a useful fallback because it makes clear whether Flash Fill is available in the version you are using.

Frequently Asked Questions

What does Ctrl+E do in Excel?
It runs Flash Fill, which detects a pattern in examples and fills the selected or suggested cells with matching results.

Is Ctrl+E the same as Fill Down?
No. Flash Fill infers a text or data pattern from examples. Fill Down copies the contents or formula of a cell into cells below it.

Why is Ctrl+E not working in Excel?
Excel may not have enough examples to identify a pattern, or Flash Fill may not be available in the current interface. Add a clear sample, select the target range, try Data > Flash Fill, and check whether your Excel version supports the command.

Does Flash Fill update when I change the original data?
Usually not. Flash Fill writes results rather than creating live formulas, so rerun it or revise the output when the source values change.

Can Flash Fill split or combine text?
Yes. It can often extract or combine text when you demonstrate the desired result in one or more examples. Review exceptions because Excel infers the pattern rather than applying a rule you have explicitly defined.

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.