excel查找定位删除0值_查找和删除Excel行的快速方法

excel查找定位删除0值

It's finally summer, and you need to stay cool, even when you're using Excel. Here's an energy-efficient and fast way to find and delete Excel rows. You can select several rows that contain similar data, and delete them all at the same time.

终于到了夏天，即使使用Excel，也需要保持凉爽。 这是一种查找和删除Excel行的节能高效的方法。 您可以选择包含相似数据的几行，然后将其全部删除。

查找所有数据 (Find All the Data)

In the worksheet shown below, there is a list of products sales, and a few of the records are for paper sales.

在下面显示的工作表中，有一个产品销售清单，其中一些记录是关于纸张销售的。

I'd like to delete those paper sales rows, without having to sort the worksheet, or spend a long time manually selecting the rows.

我想删除那些纸张销售行，而不必对工作表进行排序，或者花很长时间手动选择行。