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?