Excel Flash Fill shortcut: Ctrl + E
Type one or two examples and let Excel fill the rest by the same pattern.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
What it does
Ctrl + E starts Flash Fill. Excel looks at the examples you typed next to your data, finds the pattern, for example the first name from a full name, and fills the rest of the column to match.
When to use it
Use it to split or join text without formulas: first names from full names, initials, parts of a code, or a date written another way. It is the fastest way when the pattern is obvious.
How to do it
- Type the first result next to your data, for example Anna next to Anna Smith.
- Type the second result, and stay in the next cell below it.
- Press Ctrl + E. Excel fills the rest of the column.
A quick example
Column A holds full names. In B2 type Anna and in B3 type Ben, then select B4 and press Ctrl + E. Excel fills B4 to B7 with Cara, Dan, Eva and Finn.
Flash Fill, Text to Columns and formulas
Flash Fill learns from your examples and writes fixed text. Text to Columns on the Data tab splits text at a separator such as a space or a comma. Formulas update when the source changes. Choose Flash Fill for speed, and a formula when the data will change.
Not working? Check this
- Nothing happens: you must be on the cell directly below your examples, in the column next to the data. Click into the sheet first, not into the formula bar.
- Wrong results: the pattern was not clear. Type a third example and press Ctrl + E again.
- Flash Fill is off: in desktop Excel turn on Automatically Flash Fill under File, Options, Advanced.
- On a Mac try Command + E, or Data, Flash Fill.
- The letter keys are the English ones. In some language versions of Excel the letters differ. If the keys do nothing in yours, use the matching button on the ribbon instead.
Quick answers
What is the shortcut for Flash Fill?
Type one or two examples next to your data and press Ctrl + E. On a Mac try Command + E.
Does Flash Fill update by itself?
No. It writes fixed values. If the source data changes, run Flash Fill again or use a formula.
Why does Flash Fill not work?
The examples must be directly next to the data, with a clear pattern and no empty column between. Type another example and press Ctrl + E again.

