Excel Troubleshoot formulas with CTRL+' to show/hide formulas or values. Review all the formulas in your workbook quickly. On Friday, a longer article will tell you about troubleshooting worksheets. Here’s how to get started:

Switch from values to formulas with CTRL+`(that's single quote, the key just above the tab key on your Irish / English keyboard). You can also click 
Show/Hide formulas in the Formulas tab, Auditing Tools group.

That’s brilliant when you have a lot of calculations and you need to check that they are consistent for instance. Think it’s useful and everybody should know about this? Comment, Share or Like this tip. We love our followers.

 

Excel Training Tip toggle formulas and values with a shortcut