How can I delete specific cells within a list?

  • Thread starter Thread starter Chris Mitchell
  • Start date Start date
C

Chris Mitchell

How can I delete cells, (note not the content of these cells, but the cells
themselves) within a list that contain a specific value '0' without changing
the order of the remaining items in the list?
 
Hi Chris,

Try this,
Assuming your list is in column A.
Put this in helper column B =IF(A1=0,NA(),"")
and drag down to the end of your data.
While column B is still highlighted tap the F5 key,
This will bring up the Go To dialog box
Click the Special button
Check Formulas
Uncheck Numbers, Text and Logicals
Leave Errors checked And OK out

This will leave only the #NA errors highlighted
Right click on one of these
Select delete and check Entire row
OK and you should be done.

HTH
Martin
 
In xl2002+ you can choose Edit > Find, type '0' then Find All.
Select all items in the list (Ctrl+A) then Edit > Delete > Entire Row.
 
Back
Top