View Formulas in Excel

If you've ever wanted to check over your formuals in an Excel spreadsheet, but found it annoying to have to click on each cell to view the formula, this trick might be just the thing you're looking for!

If you press:

Ctrl + ` (that's the control button, and the apostrophe on the same key as ~)

You will be able to see all of the formulas in your sheet, making it easy to troubleshoot. When you're done, you can press Ctrl + ` again to make everything go back to normal. And don't worry, it'll probably stretch out a bunch of your columns so you can see the entire formula, but everything goes back to how you had it before when you change it back.


Post a Comment