Forum Discussion

Olaf Hubel's avatar
Olaf Hubel
Former Employee
Jul 19, 2017

NEW: Welcome to Excel template

If you’re new to Excel, or even if you have some experience with it, you can walk through our most requested features in this tour. With real-world examples and helpful visuals, you’ll be able to sum...
Excel Desktop
tips and tricks
Fanny Guyot's avatar
Fanny Guyot
Copper Contributor
Jul 24, 2017

Good Morning,

 

I looked throught your document but unfortunately it didn't help me. In fact, i have a very big database and I would like to delete the rows in which some cells equals to 0. At first, I wanted the cells to be blank so I unticked the "Show a zero in cells that have zero values" checkbox and tried to delete the blank cells but it didn't work as the cells weren't really blank. So I'd like to know if it was possible to use a formula that can delete rows in which some cells are equals to zero.

 

Thank you in advance for your time and your help,

Have a great day

Best,

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 24, 2017

Hi Fanny,

 

Straightforward manual variant could be like this (assuming for this example your zero cells are in one column). Select this column and apply Filter in Data tab of Ribbon

 

Filter only cells which you want to delete (with zeros) 

 

Select them and Delete Rows from right click menu

 

You see only the filter now

 

Expand filter and select all

 

 

Now you have all your rows but ones with zeros

 

If such transformation is repeating operation better to use Get&Transform then. And be sure you have a backup before deleting.

Resources