1
Enter one example manuallyType the desired output in the first row
Enter just the first name, just the code, or whatever the target format is — one row only.
Ctrl+EFlash FillText Formatting
Split and Combine Text Instantly with Flash Fill (Ctrl+E)
Formulas aren't too slow — it's just that for one-off text cleanup, Ctrl+E is often dramatically faster.
Shortcuts you will master in this article
Ctrl + E / Ctrl + D / Ctrl + Z
You Don't Need a Formula for Every Text Transformation
Splitting first and last names, extracting department codes, standardizing formatting — if the pattern is clear, Excel can often figure out the rest once you show it one example.
Ctrl+E trades long-term reusability for immediate speed. It's ideal for one-off jobs or quick fixes.
How to Use Flash Fill
The key is giving Excel a clear, single example to learn from.
2
Ctrl + ELet Excel fill in the rest
Excel infers the pattern from your example and applies it to the remaining rows.
3
Ctrl + ZUndo immediately if the result is wrong
Flash Fill can misread ambiguous patterns, so always verify and be ready to undo.
4
Ctrl + DCombine with formulas or helper columns as needed
Use Fill Down to extend results to a separate column after Flash Fill has done its work.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
When Flash Fill Shines
Great for name splitting, email-to-ID extraction, digit padding, and similar structured transformations.
The more consistent the source data, the more accurate the result.
If you'll run this transformation every month, build a formula. If it's a one-time fix, Flash Fill wins.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + E | Flash Fill |
Ctrl + D | Fill Down |
Ctrl + Z | Undo |
Frequently Asked Questions
Q. Flash Fill isn't picking up the pattern correctly.
A. The source data may have inconsistencies, or the example may be ambiguous. Make sure your first example is as clear and specific as possible.
Q. When does Flash Fill beat formulas?
A. For one-time transformations and ad hoc data cleanup where speed matters more than repeatability.
Q. Will the results update automatically if the source data changes?
A. No. Flash Fill outputs static values. Unlike formulas, it won't recalculate when the source changes.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →