Excel 2002 offers a new tool- the ability to do a global search for some text in the workbook and see all instances of that text listed.
In the prior versions, you would have to find each instance one at a time.
As you may recall, to do a search in Excel you can either:
Go to the Edit menu, then select Find or
Click the Ctrl and F keys at the same time as a shortcut method
You then get this popup dialog box.
What is new is the Find All button. In this case, we decide to do a search on a state (so we match the case).
Here is the result.
Down in the bottom section, we get a list of all the instances with the value we selected.
You can even cover all the sheets in a workbook. We did this on a one sheet workbook, but to pick all the sheets, click on the drop down arrow in the Within box and change it to Workbook instead of Sheet.
One more nice feature of Excel 2002.