Where Is the Flash Fill Button in Excel? Find It Fast

In Excel for Microsoft 365 on Windows, Flash Fill is on the Data tab, in the Data Tools group. You can also run it with Ctrl+E after entering an example of the pattern you want; Excel then fills the remaining rows it can recognize.

Find Flash Fill on the ribbon

Open the workbook and select the Data tab on the ribbon. Look in the Data Tools group for Flash Fill. The command may appear as a labeled button or as an icon, depending on the width of the Excel window and ribbon layout. If the ribbon is compressed, expand the window or inspect the group for its available commands.

Flash Fill is a built-in Excel command, not a formula or an add-in you need to install. In the standard Windows ribbon, its path is Data > Flash Fill. You can also use the command from the Home tab in some ribbon layouts, but the Data tab is the dependable place to look.

If you cannot see the button, first check that you are using the desktop Excel app rather than Excel for the web. The web version does not provide the same Flash Fill command in its ribbon. In desktop Excel, confirm that the Data tab is visible and that the ribbon is not collapsed. You can widen the window or use Excel’s ribbon display options to show more commands.

Run Flash Fill with an example

Flash Fill works best when your source data is in one column and you enter the desired result in a neighboring column. For example, suppose A2 contains Jordan Lee and A3 contains Avery Patel. To extract first names, type Jordan in B2, move to B3, and press Ctrl+E. Excel may show a preview of the proposed results; press Enter to accept it. You can also choose Data > Flash Fill.

Keep the original data intact and add a blank column beside it for the results.
Type the result you want for the first source row. Be precise about spaces, punctuation, capitalization, and formatting.
If the pattern is not obvious, enter a second example in the next row. Examples help Excel distinguish the intended transformation from other possibilities.
Select the next blank destination cell and use Ctrl+E, or choose Data > Flash Fill.
Review the filled cells before using or sharing them. Correct any wrong results directly or provide clearer examples and run the command again.

For a shortcut on Windows, Ctrl+E starts Flash Fill. In Excel for Mac, try Control+E; if the shortcut is unavailable or behaves differently with your keyboard setup, use Data > Flash Fill instead. A keyboard shortcut is convenient, but the ribbon command makes it easier to confirm which operation you are running.

What Flash Fill does and how it recognizes patterns

Flash Fill looks at example results you type and tries to apply the same visible pattern to the surrounding data. It can recognize common transformations such as taking part of a name, joining text from multiple columns, changing the arrangement of text, or applying a consistent punctuation style. It is designed for repeated, recognizable patterns in rows of data.

It is not a formula engine that understands what a name, address, or email address means. Instead, Excel infers a pattern from the examples and nearby values. If the data is inconsistent or the examples could support more than one interpretation, it can make a plausible but incorrect guess. For instance, one sample may not make clear whether you want a first name, a middle initial, or a particular number of characters. A second or third example can make your intention clearer.

Flash Fill generally puts its results into cells as values rather than leaving a formula that calculates from the original data. That makes it useful for preparing a one-time list, but it also means the results do not automatically change when the source text changes. Treat the output as generated data that needs review, not as a permanent live connection to the source.

Useful examples of Flash Fill

These examples illustrate patterns Excel may be able to infer. The exact result depends on the consistency of the source rows and on the examples you provide.

Split a name: With full names such as Jordan Lee in column A, type Jordan in the adjacent column to extract first names. You could make a separate output column for last names by providing a sample such as Lee.
Join separate fields: If first and last names are in different columns, type a sample full name with the intended space between the parts, then run Flash Fill down the output column.
Format phone numbers: Enter one example showing the desired punctuation or spacing. Check the results carefully, especially if the source includes country codes, extensions, or leading zeros.
Extract text from email addresses: Examples can show that you want the text before the at sign, or the domain after it. Check addresses with different formats, subdomains, or unusual characters.
Create initials or labels: You can demonstrate a pattern such as initials from names or a short code formed from a longer description. Use enough samples to show how multi-part names or exceptions should be handled.

A useful rule is to test Flash Fill on a small section before applying it to a large table. Compare the generated values with the source rows, including records that look different from the typical case. Examples that cover variations—such as a middle name or a hyphenated surname—are more informative than repeating the same simple pattern.

Automatic Flash Fill and when to use the button

Excel may offer Flash Fill automatically as you type when it detects a pattern. If a preview appears and matches what you intended, press Enter to accept the suggestion. If no suggestion appears, or if you want to run the operation on demand, select the destination cell and use Ctrl+E or the ribbon button.

In Excel for Microsoft 365 on Windows, automatic Flash Fill can be controlled in File > Options > Advanced, under the editing options. Look for Automatically Flash Fill. If the setting is turned off, the manual button and shortcut are still useful ways to invoke the feature. If you work on a Mac, use the Data tab command when you do not see an automatic suggestion; Windows option paths do not apply to the Mac interface.

Manual use is often preferable when a worksheet contains several nearby columns or when Excel’s suggestion is ambiguous. It lets you decide when to generate results and gives you a chance to provide a deliberate example first. Automatic suggestions can save keystrokes, but accepting one without checking it can spread an incorrect assumption through many rows.

Limitations and common mistakes

Flash Fill is most reliable when rows follow a consistent structure. It may struggle when some values have extra spaces, missing parts, different separators, or multiple valid formats. For example, an email list might contain both ordinary addresses and shared mailboxes with a different naming convention. A pattern that works for most rows may not produce the intended result for every exception.

Because its output is not a live formula, a change to the source does not necessarily update the filled result. If a customer changes a name after you have run Flash Fill, you may need to edit the output or run the operation again and review the new results. Keep a copy of the original column until you have checked the generated data.

Take special care with identifiers that look like numbers, including postal codes, account codes, and phone numbers. Such values may contain leading zeros or punctuation that matters. Excel can interpret entries as numbers or dates in some circumstances, and a displayed value may not preserve the exact text you need. Format destination cells appropriately and compare the underlying results with the source before deleting anything.

Flash Fill is also not a substitute for validating data. It does not prove that an extracted email domain exists, that a name was split correctly, or that a phone number is valid. It applies a pattern; the person using the worksheet remains responsible for checking whether the result makes sense.

Troubleshoot when Flash Fill is missing or gives the wrong result

If the command is not visible, work through these checks before assuming it has been removed:

Make sure you are in the desktop version of Excel, rather than Excel for the web.
Open the Data tab and look in the Data Tools group. Expand the Excel window if the ribbon has collapsed or hidden labels.
Enter the example in a column next to the source data, then select the next destination cell before using the command.
Try a second example that makes the intended pattern more specific, then run Flash Fill again.
Check whether automatic Flash Fill is disabled if you expected Excel to offer a preview while typing.

If the button runs but the results are wrong, undo the operation immediately with Ctrl+Z on Windows or Command+Z on Mac, if you have not made other edits you need to preserve. Then revise the examples, use a separate output column, and try again. If only a few rows are exceptions, correct those cells manually and keep a record of the rule you applied.

Flash Fill compared with formulas and Text to Columns

Flash Fill is a quick choice when you need to demonstrate a straightforward transformation and produce a set of values. Its advantage is that you do not need to write a formula. Its trade-off is that the generated output does not recalculate when the source changes, and Excel’s inferred pattern can require manual checking.

Use a formula when the result should update automatically as source cells change, or when you need a rule that can be inspected and repeated consistently. Formulas are also more suitable for workbooks where the transformation must be maintained by other people. For a one-time cleanup, Flash Fill may be faster; for a recurring import or a carefully controlled process, formulas or Power Query may be more appropriate.

Text to Columns, on the Data tab, is a better fit when records are separated by a consistent delimiter such as a comma, space, or tab, or when a fixed-width layout defines where each field ends. Flash Fill is pattern-driven and can handle transformations that are not simply a split at one delimiter. The choice depends on the shape of the data: use Text to Columns for predictable field boundaries and Flash Fill for a repeated example-based rewrite.

Frequently Asked Questions

Where is Flash Fill in Excel 365?
In desktop Excel for Microsoft 365 on Windows, open Data and find Flash Fill in the Data Tools group. The shortcut is Ctrl+E.

What is the shortcut for Flash Fill?
Use Ctrl+E in Excel for Windows. In Excel for Mac, try Control+E; if it does not work with your setup, run the command from Data > Flash Fill.

Why is Flash Fill not working?
Excel may not recognize the intended pattern, the destination may not be beside the source data, or automatic suggestions may be turned off. Provide clearer examples and run the command manually from the Data tab.

Does Flash Fill update when the original data changes?
No. Flash Fill creates results rather than a formula that continuously refers to the source. If the source changes, review and update the generated values or run Flash Fill again.

Can I use Flash Fill in Excel for the web?
The full Flash Fill command is a desktop Excel feature and is not available in the same way in Excel for the web. Open the workbook in the desktop app to use the ribbon command or its keyboard shortcut.

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.