What is the shortcut for Flash Fill?
Windows: Ctrl+E. Mac: Ctrl+E.
📊Excel Shortcut
Flash Fill
Detailed guide to use "Flash Fill" in Excel
Shortcut Keys
The highlighted keys show where to press. Press the required keys together.
Windows
Ctrl
E
Windows shortcut: Ctrl+E
Mac
Ctrl
E
Mac shortcut: Ctrl+E
In Action
This shows a representative pseudo-Excel example of what happens after the shortcut runs. The actual Excel UI may differ slightly.
Auto-playing example
Active: B2Selection: B2:B5Sheet: Sheet1Step 1/2
You can scroll the sheet horizontally
↶↷BIUGeneral
Name Box
B2
Formula Bar
fxAki◢ | A | B |
|---|---|---|
| 1 | Full Name | First Name |
| 2 | Aki Sato | Aki |
| 3 | Mina Ito | |
| 4 | Ken Mori | |
| 5 | Sora Abe |
Sheet1
Ready100%
Basic Info
- Category
- Copy & Paste
- Difficulty
- ★★☆(Intermediate)
How to Use
- 1Select the target cell/range if needed
- 2Press the highlighted keys shown above together
- 3Flash Fill is executed
Practice
Practice this shortcut and build reliable muscle memory.
Usage Tip
Fill values automatically based on a detected pattern.
FAQ
How do I use Flash Fill?
Use it after selecting the target cells to keep copy-and-paste work moving without reaching for the mouse.
What shortcuts should I practice after Flash Fill?
Practice copy, paste, and cut next and you can move through common Excel work much faster.
Where can I practice Flash Fill?
Use the page button to start a focused drill right away. If you switch to full practice, you can review copy, paste, and cut in the same flow.
What is the action preview for Flash Fill?
A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.