ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   find (https://www.excelbanter.com/excel-worksheet-functions/90812-find.html)

Mindy

find
 
Hello, for some reason when I try to use the find tool, its not working. For
example, I go to the edit menu and click on find. In find what I put Paul,
the within is set as sheet, search is set to by columns, and look in is set
to values. When I click on find next, it says microsoft office excel cannot
find the data you're searching for. But I see the name on the worksheet.

Daniel CHEN

find
 
Make sure the following two check boxes are not checked.
1-Match Case
2- Match Entire Cell Contents


--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Mindy" wrote in message
...
Hello, for some reason when I try to use the find tool, its not working.
For
example, I go to the edit menu and click on find. In find what I put
Paul,
the within is set as sheet, search is set to by columns, and look in is
set
to values. When I click on find next, it says microsoft office excel
cannot
find the data you're searching for. But I see the name on the worksheet.




Mindy

find
 
neither of those are checked.

"Daniel CHEN" wrote:

Make sure the following two check boxes are not checked.
1-Match Case
2- Match Entire Cell Contents


--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Mindy" wrote in message
...
Hello, for some reason when I try to use the find tool, its not working.
For
example, I go to the edit menu and click on find. In find what I put
Paul,
the within is set as sheet, search is set to by columns, and look in is
set
to values. When I click on find next, it says microsoft office excel
cannot
find the data you're searching for. But I see the name on the worksheet.






All times are GMT +1. The time now is 12:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com