Finding Cells in an Excel Document
If you happen to have a very complex spreadsheet, one filled with many, many formulas and functions, you may find it tedious to find each of the cells that contain formulas and check your typing. One of the worst errors you can have is a formula that calculates incorrectly rather than producing an error message. These formulas have to be re-typed with the correct formulas or function. If you should have a rather complex document with formulas getting data from other cells that also contain formulas, finding the exact cause of the error can be something of a challenge. Excel comes to the rescue by providing a quick way to identify the cells in a spreadsheet that have something in common -- their cell contents are determined by formulas.
The example shown is too elementary to require help in finding cells with formulas, but it illustrates the cell finding process nicely.
Suppose you wanted to know which other cells also contain their contents based on a formula. Choose Edit + GoTo to open the GoTo wizard.
This should bring out the GoTo Wizard. Select the Special Button.
Choose the characteristic FORMULAS from the list of choices.
Click on the OK button when you finish.
When you do you will see your spreadsheet and all of the cells containing formulas will be highlighted to make them easy to find and hopefully find the formula that needs reworking!
