#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mindy
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel CHEN
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mindy
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find Function Guy Lydig Excel Discussion (Misc queries) 2 May 19th 06 07:19 PM
Find and Replace blakrapter Excel Worksheet Functions 3 December 15th 05 12:25 AM
Code needed to find records from bottom up Andy Excel Discussion (Misc queries) 4 December 5th 05 03:27 AM
find a cells from a range of cell kelvintaycc Excel Worksheet Functions 2 April 2nd 05 07:20 PM
Excel has a "Find Next" command but no "Find Previous" command. Michael Fitzpatrick Excel Discussion (Misc queries) 2 January 10th 05 11:45 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"