Flash Fill in Excel: Keyboard Shortcut and How to Use It

To use Flash Fill in Excel for Microsoft 365 on Windows, type one example of the result you want in the column beside your source data, select the next cell below it, and press Ctrl+E. Excel detects the pattern and fills the remaining rows. Flash Fill is useful for splitting or combining text, changing letter case, and reformatting values without writing a formula.

What You’ll Need

A desktop version of Excel with Flash Fill, such as Excel for Microsoft 365 on Windows. Excel for Mac also has Flash Fill; its shortcut can depend on the keyboard setup, so the ribbon command is a reliable alternative.
A column of source data and a blank destination column beside it. Flash Fill works best when the source rows are continuous and the examples follow a consistent pattern.
One or more correctly typed examples showing the exact output you want. Check spelling, spaces, punctuation, and capitalization before filling the rest.

Flash Fill is a pattern-recognition tool, not a worksheet formula. It writes values into cells, so results do not automatically change if you later edit the source text. Save a copy first if you are working with important data or plan to replace existing results.

Step-by-Step

Arrange the source and output columns. Put the original information in one column and leave the column immediately to its right empty for the results. Include a header for each column if that will help you keep track of the data. For example, put full names such as ‘Jordan Lee’ and ‘Casey Morgan’ in A2:A20, then label B1 ‘First name’. Avoid placing unrelated values in the destination column because Excel may mistake them for part of the pattern or overwrite them.
Decide on one consistent transformation. Flash Fill works best when every row should be handled in the same way. You might extract the first name from each full name, join a first and last name, or change the format of an ID. Consider exceptions before you start: a row with a middle name or a hyphenated surname may require a different result from the other rows. If the output rules vary, separate the data into groups or use a more controlled method.
Type the first answer manually. In B2, enter the first name from A2, such as ‘Jordan’. Do not copy and paste the original value if you want Excel to infer a transformation; type the intended result yourself. The example should be accurate and should demonstrate the output format exactly, including capitalization and punctuation. If your first source entry is unusual, use a typical row instead, then make sure the output aligns with that source row.
Add a second example when the pattern may be unclear. In B3, type the correct result for A3, such as ‘Casey’. This extra example is especially helpful when Excel might interpret the first entry in more than one way, or when the source values contain spaces, initials, or multiple parts. Two examples are not always required, but they give Excel more evidence about your intent. Make sure each example is beside the source row it came from.
Run Flash Fill with the keyboard shortcut. Select the first blank cell below your examples, such as B4, and press Ctrl+E on Windows. Excel should infer the pattern and populate the destination cells for the rows with neighboring source data. If you prefer to use the ribbon, select the destination cell and choose Data > Flash Fill. The command is in the Data Tools area of the Data tab. If Excel fills only part of the list, inspect where the adjacent source data stops and whether there are blank rows.
Check the generated values before relying on them. Scan the top, middle, and bottom of the filled range, and pay particular attention to unusual source entries. Confirm that the first and last names, dates, codes, or other pieces are being interpreted correctly. Flash Fill can produce a plausible-looking result that is wrong for an exception, because it infers a pattern rather than understanding the meaning of your data. Correct any incorrect cells manually or revise the examples and run the command again.
Keep the results or replace the source only after checking. Flash Fill creates fixed values, not formulas linked to the original column. If a source name changes later, the corresponding filled result will not update automatically. Keep the original data if you may need to refresh the transformation, or copy the completed results to another location if you need to preserve them before editing. If you decide to undo an immediate fill, use Ctrl+Z before making other changes.

For a combine example, suppose first names are in A2:A20 and last names are in B2:B20, with a blank output column C. Type ‘Jordan Lee’ in C2 using the values from A2 and B2, then type the correctly combined name in C3. Select C4 and press Ctrl+E. Excel can infer that the two adjacent values should be joined with a space. If you want a comma, a middle initial, or a different separator, include it in your example; do not assume Excel will choose your preferred punctuation.

In Excel for Mac, try Control+E if that shortcut is available in your setup. If it does not trigger Flash Fill, use Data > Flash Fill from the ribbon instead; the Mac key mapping can vary with the keyboard and system configuration. On Excel for the web, look for Flash Fill on the Data tab. If the command is not available in your current browser version, open the workbook in the desktop app to run it.

Common Mistakes

Providing only an ambiguous example. A single example can match several possible patterns. If a full name includes a middle name, for instance, a first result that omits it may not make clear how to handle other rows. Add another representative example before running the fill.
Leaving inconsistent spaces or punctuation. Extra spaces, inconsistent hyphens, and mixed separators in the source can lead to unexpected outputs. Clean the source first when practical, and use examples that show the exact desired spacing and punctuation.
Expecting live results. Flash Fill writes values. It does not create a formula that recalculates when the source changes. Keep this difference in mind before deleting or overwriting the original column.
Filling over data you wanted to keep. Check the destination column and the extent of the selected range before using the ribbon command. A blank output column is safer than one that already contains notes or other results.
Trusting every row without review. Flash Fill can misread exceptions such as two-part surnames, suffixes, inconsistent date formats, or codes with different lengths. Review all rows when accuracy matters, not just the first few.

Tips

Use representative examples. If your list includes ordinary names and names with middle initials, provide examples that show how you want both kinds treated. Examples that cover the meaningful variations usually help more than typing many examples that all look alike.
Keep the source close to the output. Place the target column directly beside the data when possible. This makes the relationship between each source row and its intended result clear to Excel and easier for you to check.
Use a header, but start examples on matching rows. A heading such as ‘Email username’ is useful for people reading the sheet. Type the first result on the same row as its source value; do not put an example in a header cell or shift it one row out of alignment.
Use the ribbon if the shortcut is unavailable. On Windows, Ctrl+E is the standard Flash Fill shortcut. If a keyboard layout, remote desktop, or another application intercepts it, use Data > Flash Fill instead.
Know when a formula is a better choice. Use Flash Fill for a quick, one-time cleanup when you can verify the results. If the source data will keep changing, a formula or a repeatable data-preparation process is usually better because it can update or be rerun consistently.
Check automatic filling settings if Excel acts unexpectedly. In Windows desktop Excel, automatic Flash Fill can be controlled in File > Options > Advanced, under the editing options. The setting affects automatic suggestions while you type; you can still try the manual shortcut or Data tab command.

Troubleshooting

Ctrl+E does nothing: First click a blank cell in the intended output column, directly beside the source data, and try again. Confirm you are using desktop Excel or that Flash Fill is available in your web version. If the shortcut is intercepted, choose Data > Flash Fill. If the command is missing or unavailable, check your Excel version and update the app if appropriate.
Excel fills the wrong pattern: Undo the result immediately with Ctrl+Z, correct the example cells, and add another example that distinguishes the intended pattern. Then run Flash Fill again. For example, if Excel includes a middle initial when you wanted only the first name, provide a second example from a row that contains a middle initial and make the desired output explicit.
Only some rows fill: Look for blank rows in the source, gaps in the destination, or an unexpected stopping point in the data. Remove accidental breaks or run Flash Fill separately for each continuous block. Check that every example is on the same row as its corresponding source value.
The result is close but has errors in special cases: Review the exceptions individually and correct them manually. Flash Fill does not know that two similar-looking entries have different business meanings. If there are many exceptions or the rules are complex, use a formula, Power Query, or another repeatable process instead of relying on pattern guesses.
The output does not change after editing the source: That is expected because Flash Fill writes static values. Run Flash Fill again using fresh examples, or switch to a formula-based approach if the output must stay synchronized with the source.

Frequently Asked Questions

What is the Flash Fill shortcut in Excel for Windows?
Press Ctrl+E after entering an example in the output column. The command is also available at Data > Flash Fill.

Does Flash Fill work in Excel for Mac?
Flash Fill is available in Excel for Mac. Try Control+E, and use Data > Flash Fill if the shortcut does not work with your keyboard setup.

Can Flash Fill combine columns as well as split text?
Yes. Type an example that combines the neighboring values in the format you want, including any spaces or punctuation, then run Flash Fill for the remaining rows.

Does Flash Fill create formulas?
No. It inserts values based on the pattern it detects. Those values will not update automatically when you change the source cells.

Why does Flash Fill guess incorrectly?
It recognizes patterns from nearby examples, and some data can support more than one interpretation. Add clear examples, especially for unusual rows, then review the results. For complex or changing rules, use another method.

Can I undo a Flash Fill?
Usually, press Ctrl+Z immediately after the fill. If you have already made other edits, undo may reverse those instead, so check the results before continuing with more work.

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.