How do I conditionally delete rows based on cell contents?

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

Guest

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.
 
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
 
You must log in or register to reply here.

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
complex sort search and replace macro 2
Excel VBA 1
Deleting Rows based on a Value 1
Delete Rows using If and Wildcard 2
HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL 3
Allow Delete cells but not rows 1

Back
Top