Hiding under the Find & Select drop down is Go To Special…
Find & Select, can be found on the Home Menu and is the Editing section. Click on the drop down and choose Go To Special…
This powerful little tool can be very handy when you are looking for particular parts of your spreadsheet.
For example, you can get it to highlight all the cells that have formulas in them. What if you want to see all the cells that have conditional formatting? Go To Special can do that too. Want to compare two rows of data and find the cells that are different? Go To Special is your go to for that too!
Other useful options are:
Constants – highlight all the cells that are not formulas (or blank) and you can specify which type of constants – Numbers, text etc.
Precedents – highlight all the cells that the current cells’ formula uses.
Dependents – highlight all the cells that current cell is used in their formulas.
So, next time you are searching for something in your spreadsheet, Go To Special… might be able to help you find it more easily.
For finding Formulas, Notes, Conditional Formatting, Constants, and Data Validation you can do directly from the drop down of Find & Select.