Ask Your Question
0

Delete Every Row with a 0

asked 2019-05-16 06:55:35 +0100

Chaython gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2019-05-16 13:38:30 +0100

Opaque gravatar image

Hello

  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
    image description

  3. Select Quantity=0
    image description

  4. Select all rows and right click (mouse on row numbering)
    image description

  5. Unselect filter in column Quantity
    image description

You are done.

If the answer is correct or helped you to fix your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more

Comments

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

Chaython gravatar imageChaython ( 2019-05-16 21:47:01 +0100 )edit

My words fail ...

Opaque gravatar imageOpaque ( 2019-05-16 22:16:21 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-16 06:55:35 +0100

Seen: 41 times

Last updated: May 16