Miracle of Flash Fill - Separate Names with Keyboard Shortcuts Customer lists with full names in one column can slow down your analysis and make reports messy. Instead of building formulas with LEFT, RIGHT, or TEXT, use Excel’s hidden speed tool: Ctrl E. This Keyboard shortcut activates Flash Fill, which learns your pattern from one example and instantly completes the rest of the column. How it works? Full names in Column A (Alex Johnson, Maria Garcia). In Column B, type the first name once → pr

5.1K views · 59 reactions | ✨ Astuce de pro : CTRL + E pour une...

Average Excel Tips 🔹 Ctrl Shift $ – Currency format 🔹 Ctrl Shift @ – Time format 🔹 Ctrl Page Down – Next sheet 🔹 Ctrl Space – Select entire column 🔹 Ctrl Shift (Plus) – Insert row/column 🔹 Alt F8 – Open macro dialog 🔹 Ctrl Shift L – Toggle filters on/off 🔹 Ctrl T – Create table 🔹 Alt H O A – Auto-fit row height 🔹 Ctrl Shift ! – Number format 🔹 Ctrl (Plus) – Insert cells 🔹 Alt H O I – Auto-fit column width 🔹 Alt A M – Remove duplicates 🔹 Alt W F – Freeze panes 🔹 Shift Space – Selec