By Marlo Anderson – The Tech Ranch
Checking someone else’s spreadsheet? Press Ctrl + ` in Excel to see every formula at once instead of just the answers.
The Shortcut
- Ctrl + ` shows formulas
- Press it again to show results
- The ` key is above Tab
Bonus Tip: Ctrl + T Makes a Table
Click inside your list and press Ctrl + T. Excel adds stripes and filter buttons to every column.
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.
