Hello it is time for some more #formulafridayfun. Today I want to share with you a question a colleague asked me this week. It was a great question!. How can I see at a glance by changing the cells colours, my cells that contain formulas?. That would be a handy Excel tip, especially if you have a large worksheet and need to know at a glance.
I found a really easy way to achieve this with a few clicks.
- Home Tab
- Editing ribbon
- Hit small arrow next to Find and Select
- Select GOTO – Special
- Select Formulas
- Hit Ok
- Home Ribbon
- Select the colour you want your cells to be highlighted- in this example it’s yellow
If you want to use an Excel keyboard shortcut to access the GOTO Special dialog box then simply hit the F5 key.
All of your cells containing formulas will be highlighted.
Watch The Video
If you want more Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.
If you want to see all of the blog posts in the Formula Friday series you can do so by clicking on the link below.