By Marlo Anderson – The Tech Ranch
Making the volunteer job list and typing Griddle, Coffee and Dishes for the hundredth time? Press Alt + Down Arrow and pick from what’s already in the column.
The Shortcut
- Alt + ↓: pick from entries already in the column
- Arrow keys to choose, Enter to fill it in
- Same spelling every time
- Excel on Windows
Bonus Tip: Quick Borders
Select a range and press Ctrl + Shift + & for an outline border. Ctrl + Shift + _ removes it.
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.