asked on 9th Sep 2011 | 1 Answers | Answer It!
This issue may occur if you are searching for text, values, or formatting that is contained in a filtered list, and the filtering criteria prevents the text, values, or formatting from being displayed.
To work around this issue, set the filter criteria to Show All on each worksheet in your workbook before you perform the search. To do this, follow these steps:
1. Start Excel, and then open the workbook that you want to search.
2. On the Data menu, point to Filter, and then click Show All.
3. Repeat step 2 for each sheet in the workbook.
4. Perform the search.
Here’s to Good Karma
asked on 20th Sep 2011 | 1 Answer
asked on 30th Jun 2011 | 3 Answers
asked on 3rd Aug 2011 | 1 Answer
asked on 25th Aug 2011 | 1 Answer
asked on 31st Aug 2011 | 1 Answer
asked on 2nd Sep 2011 | 1 Answer
asked on 29th Sep 2011 | 1 Answer
Here's to Good Karma