📎 This article includes 1 downloadable practice file ↓
Flash Fill (Excel 2013 and later) watches what you type and completes the column for you. Give it one or two examples, press Ctrl+E, done.
In this article
How to use it
- Next to your data, type the result you want for the first row — e.g. the first name from “Sharma, Asha”.
- Move to the cell below and press Ctrl+E.
- Check a few rows. If one is wrong, correct it — Flash Fill re-learns from the correction.
Five things it does well
| Data | You type | Result |
|---|---|---|
| Sharma, Asha | Asha Sharma | Swaps every name |
| [email protected] | Asha | First names from emails |
| 9876543210 | 98765-43210 | Formatted phone numbers |
| INV-2025-0042 | 0042 | Invoice sequence numbers |
| Asha | Sharma | AS | Initials |
If Ctrl+E does nothing, check File → Options → Advanced → Automatically Flash Fill. Practise more shortcuts in the Shortcut Trainer.
Patterns Flash Fill handles well
| Column A | You type in B | Flash Fill gives |
|---|---|---|
| [email protected] | Asha | First names from every email |
| Verma, Asha | Asha Verma | Names flipped |
| 9876543210 | 98765-43210 | Formatted numbers |
| INV/2019/000452 | 452 | The number without zeros |
| 27ABCDE1234F1Z5 | ABCDE1234F | PAN out of GSTIN |
Type one or two examples, press Ctrl+E, and check the result. If it guesses wrong, correct one more cell and press Ctrl+E again — it re-learns from your corrections.
Where it goes wrong
- It doesn’t update. Flash Fill writes values, not formulas. Change column A and column B stays the same. For data that changes, use formulas (LEFT, MID, TEXTBEFORE) instead.
- Inconsistent source data. If some rows are “Verma, Asha” and others “Asha Verma”, it will guess one pattern and silently get the others wrong. Scan the result, especially the last rows.
- It won’t trigger. Check File → Options → Advanced → Automatically Flash Fill, and make sure the column next to your data is empty and adjacent.
Test formulas dynamically in our web formula laboratory or download the companion Excel workbook.
📎 Practice files for this article
- 📗Flash Fill practice workbookPractice file from the matching course lesson.⬇ XLSX · 13 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
Stuck on a step? Ask a question and the AI answers using this article.