find more than one cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the "find" function in the Edit menu and it allows me to
find only one item on the spreadsheet at a time. is there a way for me to
find more than one cell by using this function? or should i just go manually
and scroll down until i've found the cells i am looking for?
Please help me
 
If the values are all in one column, you can use the filter (Data
->FIlter->Autofilter). This will allow you to show only rows with the cjosen
value in that column. Custom allows you more flexibility rather than just
looking for an exact (complete) cell match.

HPH
 
What version of Excel?

2002 and 2003 show a list of all the cell addresses where your Find scores a
hit.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

finding more than one item 1
Alt codes 4
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Displaying zeros in cells 2
Excel Typed text appears in wrong cell 0
Microsoft Excel - Looking up values from a range by selection by scroll of arrow keys. 1
How to give find function ( same as of ctrl F) in formula bar 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Back
Top