find

M

Mindy

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

Daniel CHEN

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
=================================
 
M

Mindy

neither of those are checked.

Daniel CHEN said:
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
=================================
Click to expand...
 
K

Kevin Vaughn

If you have selected cells before doing the find it will only search through
the selected range. This is one of things that happens to me most
frequently. I don't know if it is relevant in your situation.
 
Top