Menu
I want to remove the values from entire column where cells value is 0.
The resultant Cells should be blank.
How can I write a formula for this? Any suggestions?
TELEPHONE NUMBERS
----------
49 5235102027 <-- Cell has 0 value but shouldn't removed!
35 2578945655
0 <-- Remove this
90 5322720638
48 5396329155
703
In order to hide zero values in your Excel spreadsheet, click File on the Ribbon. Click Options, then Advanced. Scroll down about three-fourths of the way until you reach the section called Display options for this worksheet:. Underneath that, uncheck Show a zero in cells that have zero value.
(1) Select the Entire row option in the Selection type section. (2) Select Equals in the first Specific type drop-down list, then enter number 0 into the text box. (3) Click the OK button.
Press Control + H, then select Options and check Match entire cell contents and Match case. In the Find what field type a 0, and leave the Replace with field blank. Then Replace All.
This will remove all of the zeros that are stand alone.
113
I selected columns that I want to delete 0 values then clicked DATA > FILTER. In column's header there is a filter icon appears. I clicked on that icon and selected only 0 values and clicked OK. Only 0 values becomes selected. Finally clear content OR use DELETE button. Problem Solved!
7
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
