Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find more than one cell
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find more than one cell
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 "Stizzy" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
find more than one cell
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 On Thu, 13 Jul 2006 09:02:02 -0700, Stizzy wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
How do I find out how many different cell formats an existing wor. | Excel Discussion (Misc queries) | |||
Find Max and Min based on cell reference | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |