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

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, the Flash Fill keyboard shortcut is Ctrl+E. Enter an example of the transformation you want in a neighboring column, select the next cell in that column, and press Ctrl+E; Excel will try to apply the pattern to the remaining rows.

What Ctrl+E does in Excel

Flash Fill recognizes a pattern in the way you have reworked existing data, then fills other cells with matching results. It is especially useful for turning one text value into a different text value without writing a formula. For example, it can take a full name and produce a first name, or copy a consistent part of an email address.

Unlike a formula, Flash Fill does not leave a calculation behind. It writes ordinary values into the cells. Those results do not automatically update if the source data changes later. This makes Flash Fill quick for preparing a one-time list, but less suitable when the output needs to stay linked to changing source information.

Ctrl+E is the shortcut for the feature, not a command to fill a formula down. Excel may need one or more examples to infer what you mean, and it can decline to produce a result if the examples do not clearly show a consistent pattern.

How to use Flash Fill step by step

Place the original data in one column and the example output in a neighboring column. For a reliable first attempt, use data with a consistent structure and make sure the example is exactly the result you want. Then use this sequence:

  1. Type the first transformed value beside its source value. For a list of full names, you might type the first person’s first name in the adjacent column.
  2. Move to the next blank cell in the output column. You can type a second example if the pattern could be interpreted in more than one way.
  3. Press Ctrl+E. Excel analyzes the examples and the source values, then fills the output column where it detects a match.
  4. Review the results before using them elsewhere. Correct any exceptions manually, or undo the fill if it produced the wrong pattern.

You can also run the command from the ribbon: select the cells where you want the results, then choose Data > Flash Fill. The shortcut and the ribbon command invoke the same feature. If you select only one cell, Excel may still fill nearby rows based on the example and surrounding data, but selecting the relevant output range can make your intent clearer.

A worked example: extracting first names

Suppose A2:A4 contains Ada Lovelace, Grace Hopper, and Katherine Johnson. In B2, type Ada. If Excel displays a preview of suggested first names in the cells below, press Enter to accept it. If no preview appears, select B3 or the intended output range and press Ctrl+E. The resulting values should be Ada, Grace, and Katherine.

This simple example works because each source cell contains a first name, a space, and a surname, and the requested output is consistent: keep the text before the space. A different task might use the same source list but return surnames instead. To signal that pattern, type Lovelace as the example rather than Ada. The example matters: Flash Fill follows the transformation you demonstrate, not a rule you describe in words.

For a second example, imagine a column of email addresses such as maya.chen@example.com. If you type maya.chen in the adjacent cell, Flash Fill may infer that you want the text before the at sign. If you type chen instead, Excel needs enough examples to distinguish that request from other possible ways to extract text. Check the results carefully, especially if some addresses have middle initials or different naming conventions.

What kinds of patterns can it recognize?

Flash Fill is most dependable when the source values follow a regular structure and the desired output can be demonstrated with a small number of examples. Common uses include:

  • Separating or combining name parts, such as extracting a surname or creating a display name.
  • Reformatting phone numbers or postal codes when the source values are consistent.
  • Taking a username or domain from a consistently formatted email address.
  • Changing the appearance of text, such as making a consistent abbreviation or capitalization pattern.
  • Combining pieces from nearby columns into a human-readable label.

These are pattern-recognition tasks, not guarantees. For instance, if a phone-number column mixes country codes, extensions, and different punctuation, a single example may not communicate the right treatment for every row. Similarly, names can contain several spaces, hyphens, or suffixes, so a request that appears obvious for one record may not apply neatly to all the others.

Automatic Flash Fill and manual control

Excel can suggest Flash Fill automatically as you type examples. When it recognizes a likely pattern, it may show a preview of proposed entries in the remaining rows. Press Enter to accept the suggestion. If the preview is wrong, do not accept it; change the example or use a different method instead.

If Excel does not offer a preview, you can still request the feature with Ctrl+E or Data > Flash Fill. Automatic suggestions can be turned on or off in Excel’s settings. In Windows desktop Excel, look under File > Options > Advanced, in the Editing options, for Automatically Flash Fill. Turning off automatic suggestions does not mean you cannot use the manual shortcut or ribbon command.

Manual triggering is helpful when you want control over when Excel fills the column, or when you prefer not to see suggestions while entering data. If the command is unavailable or does nothing, first check that you are using a desktop version that includes Flash Fill and that automatic behavior has not been confused with the manual command.

Common problems and how to fix them

A frequent problem is that Excel fills only some rows, or produces results that look plausible but are wrong. Flash Fill is not validating your data against a formal rule. It is making an inference from examples, so review the entire output rather than checking only the first few cells.

  • No result appears: Confirm that the source data is adjacent to the output examples, enter a clearer example, and try Ctrl+E again. You can also use Data > Flash Fill.
  • The wrong text is extracted: Undo with Ctrl+Z, then provide an example that makes the intended transformation unambiguous. A second example from a differently structured row can help.
  • Some rows are missed: Look for inconsistent separators, blank cells, extra spaces, or exceptions in the source. Handle unusual rows separately or use a method with explicit rules.
  • Results do not change when the source changes: That is expected. Flash Fill creates values, not formulas. Run it again after editing the source, or use a formula or another refreshable transformation.
  • It fills the wrong area: Undo the action, select the intended destination cells, and trigger Flash Fill again. Avoid selecting unrelated data that could confuse the result.

Also check that you have not mistaken a preview for completed output. A suggested pattern is not committed until you accept it, usually by pressing Enter. Afterward, review the filled cells and save the workbook when the results are correct.

Flash Fill compared with formulas and Text to Columns

Choose Flash Fill when the transformation is easy to show with examples and the result can be a one-time set of values. It is fast for cleaning a copied list, and it does not require you to learn a formula. Its main trade-off is that the output is static and the pattern is inferred rather than explicitly defined.

Use a formula when results must update as source cells change, or when the rule needs to be clear and repeatable. Formulas can also be easier to audit in a shared workbook because another person can inspect the logic. The right formula depends on the exact data and the Excel version, so a quick Flash Fill operation may be more practical for a small, one-off cleanup.

Text to Columns, available from Data > Text to Columns, is another option when you want to split a column using a consistent delimiter or fixed-width positions. It is more rule-based than Flash Fill, which can make it more predictable for uniformly structured text. It also changes how data is laid out across columns, so consider whether you want separate columns or a newly formatted value in one column.

For repeatable imports or more involved data-cleaning workflows, Power Query may be a better fit than manual pattern recognition. The choice depends on whether the task is occasional, whether the data structure is stable, and whether results must refresh when new source data arrives.

Windows, Mac, and Excel for the web

For Excel for Microsoft 365 on Windows, use Ctrl+E or Data > Flash Fill. In Excel for Mac, the Flash Fill command is available from the Data tab; the keyboard shortcut can depend on the keyboard and Excel setup, so use the ribbon command if Control+E does not work in your installation. This avoids confusing it with a different shortcut or relying on a key mapping that may vary.

Excel for the web does not provide the same complete Flash Fill experience as the desktop app. If you cannot find Flash Fill in the browser, open the workbook in the desktop version of Excel and use the Data tab or the Windows shortcut. A workbook containing values created with Flash Fill can still be opened elsewhere; the filled results are values rather than a special formula that needs to recalculate.

Frequently Asked Questions

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

Why is Ctrl+E not working in Excel?
Flash Fill may not have enough clear examples, the selected cells may not be appropriate, or you may be using Excel for the web. Try typing a more specific example and using Data > Flash Fill in desktop Excel.

Does Flash Fill update when I change the original data?
No. Flash Fill writes static values. If you change the source later, rerun Flash Fill or use a formula or another method that recalculates.

Can I use Flash Fill on a Mac?
Yes, use Data > Flash Fill in Excel for Mac. If Control+E is not recognized in your setup, the ribbon command is the dependable alternative.

Is Flash Fill the same as Text to Columns?
No. Flash Fill infers a transformation from examples and writes results into cells. Text to Columns splits data according to a delimiter or fixed-width rule.

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.