How to delete filtered rows in Numbers?

Question

Alex_Y Author

Level 1

8 points

How to delete filtered rows in Numbers?

i`ve just tried to delete filtered rows from my table and i could not to do it.

I have a table

|Column A|Column B|

|-|-|

|X|1|

|Y|2|

|X|3|

|Y|4|

|X|5|

Then a added a filter on Column A a i selected all the X results.

After that i saw a table

|Column A|Column B|

|-|-|

|X|1|

|X|3|

|X|5|

After that i select all these rows and click on the "Delete selected rows" and remove the filter and my table was

|Column A|Column B|

|-|-|

empty

I expected to see the table

|Column A|Column B|

|-|-|

|Y|2|

|Y|4|

What do i wrong? How to delete just selected rows after filtering?

By the way, if i select rows after filter and click Backspace on keyboard or cope selected rows to the new list everything is correct...

Numbers version 10.2

MacBook, macOS 10.15

Posted on Nov 2, 2020 6:33 AM

Reply

Answer 1

Badunit

Level 7

30,360 points

Nov 2, 2020 9:23 AM in response to Alex_Y

If it is a short list of rows to delete, you can select one (click on its row number) then Command Click on each of the others to select only those rows, then delete selected rows. This would not be very practical for a lot of rows though. I like Excel's way of doing it better where only the visible rows get selected and deleted.

If you are okay with the "deleted" rows being turned into blank rows vs being gone totally, you can filter, select them like you normally would, then use the delete key. This is inconsistent with what happens when deleting selected rows.

If you can sort your table vs using a filter, it would put all the X rows together where they can be deleted as a group.

Reply

How to delete filtered rows in Numbers?

Similar questions