Welcome back to part three of my Go To Special’s Hidden Treasure series. So far, we’ve learned how to delete blank rows and fill blank cells in a data table. Now, we’re going to pivot to auditing formulas and learn how to highlight all formulas within a worksheet.
When working with a worksheet that has a lot of data and formulas, sometimes it’s hard to tell which cells are hard coded and which contain formulas. Instead of selecting each cell and checking the formula bar, you can highlight all the cells containing formulas using Go To Special.
First, select all cells containing formulas. To do this, press CTRL+G, hit the Special button, select “Formulas,” and hit OK. Now you just need to highlight them! Once done, it’s easy to tell which cells contain hard-coded data versus which cells contain calculated values. Easy peasy. Make sure to tune in next time for the conclusion of the Go To Special’s Hidden Treasures series!
