By Marlo Anderson – The Tech Ranch
Totaling up what the pancake breakfast cost? Click the empty cell under the numbers and press Alt + =. Excel writes the SUM formula for you. Press Enter and you’re done.
The Shortcut
- Click the cell below your numbers
- Press Alt + =, then Enter
- Works for rows, too
- Mac: ⌘ + Shift + T
Bonus Tip: Filter with Ctrl + Shift + L
Click any cell in your table and press Ctrl + Shift + L. Every column gets a drop-down button so you can show just the rows you want. Press it again to turn Filter off. Mac: ⌘ + Shift + F.
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. Short on time? Here’s the quick Short version.
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.
