#190: View/Hide Excel Formulas

If you’ve ever worked with an Excel spreadsheet, the odds are pretty good that you’ve had to do some troubleshooting of your formulas at some point. This week’s tip is a great help for those “fun” occassions.

You can toggle the display of your spreadsheet between the data and the underlying formulas by a simple keyboard combination.  The hardest part to using this trick is finding the tilde key –it’s way up towards the top left of your keyboard next to the number 1 key.

Hit this key combination, and presto – all of your formulas will emerge from behind the scenes. You can even print your formulas while they’re displayed this way. When you’re done troubleshooting, hit Ctrl + ~ again to toggle back to the normal view.

What’s your favorite trouble-shooting trick?

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s