Quickly See All the Formulas in Excel with This Shortcut

Google+ Pinterest LinkedIn Tumblr +

Something mistaken with some numbers in that spreadsheet? Here’s a shortcut that shows all of the formulation within the sheet without delay:

Ctrl + ` (the acute accent key, discovered subsequent to the number one in your keyboard). On a Mac, attempt Cmd + `

That’s it! With the formulation displayed, you’ll be able to click on round to see which cells and capabilities are being referenced. You can toggle again to the values view by hitting the shortcut once more.

Troubleshooting misbehaving numbers? | Twitter @Office

http://platform.twitter.com/widgets.js

Read more

Share.

Leave a Reply

%d bloggers like this: