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. |
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. |
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