Quickly See All The Formulas In Excel With This Shortcut

Quickly See All the Formulas in Excel with This Shortcut

Something wrong with some numbers in that spreadsheet? Here's a shortcut that displays all the formulas in the sheet at once:

Ctrl + ' (the acute accent key, found next to the number 1 on your keyboard). On a Mac, try Cmd + '

That's it! With the formulas displayed, you can click around to see which cells and functions are being referenced. You can toggle back to the values view by hitting the shortcut again.

Troubleshooting misbehaving numbers? [Twitter @Office]


Join the discussion!

Trending Stories Right Now