ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Despite data existing in Excel 2002 spreadsheet Find doesn't find (https://www.excelbanter.com/excel-discussion-misc-queries/94286-despite-data-existing-excel-2002-spreadsheet-find-doesnt-find.html)

AnnieB

Despite data existing in Excel 2002 spreadsheet Find doesn't find
 
In Excel 2002 spreadsheet, despite data existing, using the Find function
does not find the data. All options appear to be set correctly. Can anyone
give me some ideas on why the data is not being found?

simonsmith

Despite data existing in Excel 2002 spreadsheet Find doesn't find
 

you may have some formatting probs with your data. To test it try
copying a cell of your data into the find box - it should find that.
You may have a space or some rogue thing in your data.
Check also that you are not accidentally selecting (highlighting) a
column or row that the data is not in.

SS


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=552504



All times are GMT +1. The time now is 04:42 PM.

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