By Marlo Anderson – The Tech Ranch
Need just the first names from a list of full names? Type the first one yourself, then press Ctrl + E. Excel fills in the rest.
The Shortcut
- Type one example
- Ctrl + E: Flash Fill does the rest
- Works for names, emails, codes and more
Bonus Tip: Instant Chart
Select your numbers and press Alt + F1 for a chart right on the sheet. F11 puts it on its own sheet.
More Keyboard Shortcuts, Explained
This is part of my Keyboard Shortcuts Explained series: quick, plain-English tips that make everyday computer work faster. Watch the whole series on YouTube and subscribe to The Tech Ranch so you don’t miss the next one.
Found this helpful? Give the video a thumbs up on YouTube. Got a shortcut you can’t live without? Tell me in the YouTube comments and it might show up in a future video.
