Call us on 01223 214177 or email us
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:
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.php which explains 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.
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.