Hide / Delete rows based on value in cell

**lgimnich** · 06-29-2012, 01:52 PM

I have a spreadsheet that has numeric values that is populated in every row in column D from another worksheet in the workbook. I now want to hide or delete all of the rows if the value in column D is 0. What would the formula be for doing that, so that I do not have to do it manually hide or delete row by row. In short, if column D in any row is 0 then I want to delete (or hide) that row. Can you help me? I hope that this is pretty simple. Thanks

**GeneralDisarray** · 06-29-2012, 02:03 PM

you could always use the excel autofilter (highlight one of the headers, on the home tab click on sort-filter, select filter). Then you could just filter on the D column header to eliminate 0's --- that would be doing it manually, but just one time. Once you uncheck the 0's from the filter list, all those rows are hidden for you.