If your workbook has multiple worksheets, the default search only looks at the currently opened sheet. Other options may also prevent a match. To look at all sheets in the workbook and check other settings:
Open Search (Ctrl-F) and click on Advanced.
In the Within list, select Workbook.
Verifty that the No Format Set is selected (unless you wanted a special search).
Verify the Match case box is unchecked for a more likely match.
Click on Find Next.
FaultWire Staff Posted: 26-Mar-2010
Check out what others say about this issue and review or add your own comments and solutions!
While we believe this information up to date and accurate, FAQware is not responsible for any inaccuracies. If you find something that is out of date or inaccurate, please let us know at
so we can correct it.