How do I conditionally delete rows based on cell contents?

J

John Chan

I would like to delete a whole row based on the contents of a cell that
resides in the same row to be deleted. This would then apply to the whole
spreadsheet, row by row.
 
G

Gord Dibben

John

Data>Filter>Autofilter.

Select the column that would have the cell with the content and filter for
that value.

Then F5>Special>Visible cells and OK.

Edit>Delete row.


Gord Dibben Excel MVP



On Mon, 13 Jun 2005 14:16:02 -0700, John Chan <John
 
Top