Where Is Flash Fill in Excel? Find It and Use It

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. Type an example of the result you want in a neighboring column, then choose Data > Flash Fill or press Ctrl+E to have Excel fill the remaining rows.

Where to find Flash Fill on the ribbon

Open the workbook and select the worksheet containing your data. On the ribbon, choose Data, then look in the Data Tools group for Flash Fill. The exact spacing or arrangement of commands can vary with the Excel window size, ribbon layout, or version. If you do not see the button, widen the window or expand the Data Tools group if it is collapsed.

There is also a route on the Home tab: choose Home > Fill > Flash Fill. The keyboard shortcut Ctrl+E is often the quickest option on Windows. It can be used after you enter an example in the destination column and select the next cell, or when the relevant cells are selected. If Excel cannot identify a pattern, it may not fill the column.

Flash Fill is a data-entry and transformation tool, not a worksheet formula. The cells it fills contain values, so they do not automatically change if the source values later change. That difference matters when you decide whether to use Flash Fill or a formula.

What Flash Fill does

Flash Fill looks for a pattern in examples you provide and applies what it infers to nearby data. It is particularly useful for rearranging or extracting parts of text without writing a formula. For example, you might have full names in one column and want first names in another, or have phone numbers in a mixed format and want them displayed consistently.

The feature is designed to recognize patterns from sample results, rather than follow a set of instructions you define. That makes it convenient for a quick, one-time cleanup, but it also means you should inspect the output. Excel may infer the wrong rule if the examples could reasonably be interpreted in more than one way.

Flash Fill does not change the original source column when you fill a separate destination column. Treat the output as a new set of values and keep the original data until you have checked that the results are correct.

How to use Flash Fill step by step

Suppose column A contains full names, with a first name followed by a last name, and you want first names in column B. Enter one or two examples in B beside the corresponding source rows. Then use Flash Fill to complete the pattern.

Put the source data in a column with a clear, consistent layout. For this example, names begin in A2.
In B2, type the first name from A2. For example, if A2 contains “Maya Chen,” type “Maya.”
Optionally enter the correct first name for the next row in B3. A second example can help clarify the pattern, especially if the source data is not uniform.
Select the first empty destination cell below your example, or select the destination range you want Excel to fill.
Choose Data > Flash Fill, Home > Fill > Flash Fill, or press Ctrl+E.
Review the filled cells against the source data, and correct any exceptions manually.

You can also wait for Excel to offer a Flash Fill suggestion as you type, then accept it if the preview is right. The suggestion is not guaranteed to appear for every dataset. Using the ribbon command or shortcut gives you a direct way to request a fill when Excel recognizes a pattern.

Examples of useful patterns

Flash Fill is most dependable when examples clearly show the same transformation for each row. It can handle more than splitting a name, but a useful sample should show exactly what you want to keep, remove, or rearrange.

Extracting a first name: If A2 contains “Maya Chen,” enter “Maya” beside it. Flash Fill may return the first part of each full name.
Creating an email-style label: If a column contains names and you type a consistent example such as “maya.chen,” Excel may infer a similar lowercase pattern for other rows. Verify spelling and exceptions before using the results.
Reformatting phone numbers: Provide a sample in the desired display style, such as adding parentheses and a hyphen. This changes the text appearance of the output; it does not validate that every number is complete or correctly assigned.
Combining text: If separate columns contain a first and last name, type one combined example in a new column. Flash Fill may apply the same joining pattern down the rows.
Extracting an identifier: If each code follows a predictable layout and you enter a sample of the section you need, Excel may recognize that selection in the other rows.

These examples describe pattern recognition, not a promise that Excel will interpret every dataset correctly. Names with middle names, suffixes, punctuation, inconsistent spacing, or different code lengths can create exceptions. Add representative examples and check unusual rows rather than assuming one sample covers every case.

Automatic Flash Fill and when to run it manually

Excel can sometimes detect a pattern while you type and show a preview of values it proposes to fill. If the preview matches your intention, accept it; if it does not, do not accept it. You can instead provide another example or use the Flash Fill command after clarifying the pattern.

On Windows, the automatic behavior can be controlled through File > Options > Advanced > Editing options > Automatically Flash Fill. If Excel never suggests a fill, check whether that option is enabled. You can still request Flash Fill from the Data or Home tab, or use Ctrl+E, when automatic suggestions are off.

Manual Flash Fill is useful when you want to choose the moment Excel acts, rather than have a suggestion appear while you enter data. Regardless of the method, consider the output a proposed transformation that needs a quick review, especially before using it for reports, mailing lists, or imports into another system.

Common problems and how to fix them

If Flash Fill is missing or produces no results, start with the command location and the data layout. The feature is context-sensitive: it needs a pattern it can infer, and results are more likely when the example column is beside the source data.

The button is hard to find: Check Data > Data Tools, or use Home > Fill > Flash Fill. A narrow window may collapse ribbon groups.
Nothing happens: Enter a clear example beside the source data, then try Ctrl+E or the ribbon command. A blank destination column alone does not tell Excel what transformation you want.
The result is partly wrong: Look for rows that differ in spacing, punctuation, number of words, or structure. Add an example that represents the exception, or edit those results manually.
The output does not update: That is expected. Flash Fill produces values rather than formulas. Run it again after source data changes, or choose a formula or query-based method if the result must update automatically.
Excel does not offer an automatic preview: Check the Automatically Flash Fill setting in Excel Options, then use the command manually if needed.

Do not use a filled column without checking rows that contain blanks, duplicate-looking values, or special cases. A plausible-looking result can still be wrong—for example, extracting the wrong part of a name or omitting digits from a code.

Flash Fill compared with formulas and other tools

Choose a method based on whether you need a quick fixed result or a repeatable transformation. Flash Fill is convenient for a one-off cleanup. Because its results are values, changing the source later will not recalculate them.

A formula is often a better choice when the output must stay connected to the source. It also makes the transformation rule explicit, which can be useful when another person needs to understand or maintain the workbook. The appropriate formula depends on the data and the Excel version; formulas can be less convenient when the pattern has many exceptions.

Text to Columns is a better fit when you are splitting a column using a consistent delimiter, such as a comma or space. It provides a guided way to divide data into separate columns, while Flash Fill is more flexible about recognizing a pattern from examples. Power Query is worth considering for repeatable imports or larger cleanup tasks, because you can apply and refresh a sequence of transformation steps.

In short, use Flash Fill for a fast, reviewed result; formulas for live worksheet relationships; Text to Columns for straightforward delimiter-based splitting; and Power Query when a transformation needs to be repeated as part of a data-import process.

Excel for Mac and Excel for the web

In Excel for Mac, look for Flash Fill on the Data tab. Ribbon organization and keyboard shortcuts can differ by version and keyboard configuration, so use the visible command if a Windows shortcut does not work. The Windows path File > Options > Advanced is not the Mac settings path; do not expect identical option screens.

Excel for the web does not provide the same Flash Fill command as the desktop Excel apps. If the command is unavailable in a browser, open the workbook in desktop Excel and use the Data tab or another supported transformation method. Availability can depend on the Excel edition and update channel, so check the commands in the specific app you are using.

Frequently Asked Questions

Where is Flash Fill in Excel?
In Excel for Microsoft 365 on Windows, choose Data > Flash Fill in the Data Tools group. You can also find it at Home > Fill > Flash Fill.

What is the keyboard shortcut for Flash Fill?
On Windows, press Ctrl+E. Enter an example first so Excel has a pattern to apply, then review the result.

Why is Flash Fill not working?
Excel may not see a clear pattern. Put a representative example next to the source data, add a second example if needed, and run Flash Fill manually. Also check that automatic Flash Fill is enabled if you are expecting an automatic suggestion.

Does Flash Fill update when the original data changes?
No. Flash Fill writes values into the destination cells; it does not create formulas linked to the source. Run it again or use a formula or Power Query if you need a repeatable, updating result.

Can I use Flash Fill in Excel for the web?
The desktop Flash Fill command is not available in Excel for the web. Open the workbook in Excel for Windows or Mac to use the feature, or choose another method supported in the browser.

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.