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.
Want to get more out of Excel? We run hands-on Excel training courses for teams, on-site or online, and build custom Excel solutions when you would rather hand the work over.
