Hello, in Calc how can I delete every row with a zero.
Column A has the name of a product, Column B has the quantity available.
How can I delete all rows with 0 available.
I obviously want to do this in a batch, as there’s several hundred lines.
Thanks.
Hello
-
Select colums A and B (as per your description named “Product Name” and “Quantity” in the following example)
-
Define auto filtering unsing
Data -> Autofilter
-
Select Quantity=0
-
Select all rows and right click (mouse on row numbering)
-
Unselect filter in column Quantity
You are done.
If the answer is correct or helped you to fix your problem, please click the check mark (
) next to the answer.
This worked, but rather than selecting 0, all was selected by default, so I just un-toggled 0 which removed every line with 0
1: Select colums A and B (as per your description named “Product Name” and “Quantity” in the following example)
2:Define auto filtering unsing Data → Autofilter
3: Select all except 0
4: done
Thanks
My words fail …