What is the shortcut for Flash Fill in Excel?

The Flash Fill shortcut is Ctrl + E.

Is Flash Fill dynamic?

No. Flash Fill writes results once. Use formulas if the result should update when source data changes.

Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.

Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.

Tips & Tricks - 2026-05-12

Learn Flash Fill in Excel for splitting names, extracting codes, formatting phone numbers, combining text, and cleaning imported data.

Flash Fill detects a pattern from your example and fills the rest of the column. It is useful when formulas feel too slow for a one-time cleanup. Common uses: Split first and last names Extract part of a code Reformat phone numbers Combine text Standardize labels

Type the desired result beside the first source value. Then use: Data -> Flash Fill Shortcut: \\\ Ctrl + E \\\ Excel fills the remaining rows based on the pattern.

Flash Fill works best when the source data follows a consistent pattern. If the pattern changes, review the results carefully. For repeatable models, use formulas instead of Flash Fill.

Use Flash Fill for quick cleanup. Use formulas such as TEXTBEFORE, TEXTAFTER, LEFT, RIGHT, and MID when the workbook should update automatically.

Try the shortcut or setting on a copy of your file first. Pin the technique to your Quick Access Toolbar if you will use it daily. Pair productivity tips with Excel Tables and named ranges for fewer broken references. Explore: Tips archive · Keyboard shortcuts guide

What is the shortcut for Flash Fill in Excel? The Flash Fill shortcut is Ctrl + E.
Is Flash Fill dynamic? No. Flash Fill writes results once. Use formulas if the result should update when source data changes.
How do I remember this Excel tip? Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.
Will this tip work on Mac Excel? Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.