Have you ever wondered where the formulas are in your workbook? Perhaps you’ve inherited a file and don’t have a clue what they’ve done. Or you haven’t looked at the data for a while and would like a quick way to spot all the cells that contain a formula.
Here’s how:
- Press F5.
- Click on the Special button.
- Click on the Formulas radio button.
- Click OK or press ENTER.
If the workbook does not contain formulas you will see the message “No cells were found.” If it does, all cells will be highlighted, ready to be protected from being modified. But let’s make that the content of a future tip. (With thanks to Erica Adarve for inspiring me to write this tip!)
By the way, you might want to have another look at tip 478 which explained how you can use the Go To Special functionality to find hidden rows and columns in your worksheet.
* Unless stated otherwise, these tips were written for Microsoft Office 2010.
31 October 2016
Karen Roem offers software training and support through her company Roem Ltd. Contact her by email (Karen@roem.co.uk) or visit her website at www.roem.co.uk