Find in Excel 2000

G

gary

FIND locates the FIRST cell containing the text or number
entered in the "Find What:" box.

FIND NEXT locates the NEXT cell containing the text or
number.

Instead of doing many FIND NEXT and DELETE/ENTIRE ROW
actions, is there a way to locate ALL cells containing the
text or number, mark the rows that contain those cells,
and then delete the marked rows in one action?
 
S

Stunn

Hi Gary,

Select all of the rows that you wish to search amongst. Turn on AutoFilter
(Data>Filter>AutoFilter), click the arrow above the column that contains the
values you wish to search for. (If they can appear in more than one column,
you may need to do this a column at a time, or await a VBA solution).
Select the value from the list that appears, and the list will be filtered
to display only those rows - at this point the hidden rows are still
selected so press Alt+; to select only those displayed. Now you can delete
all of those rows at once.

HTH
Steve D.
 
Top