Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Function | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Code needed to find records from bottom up | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |