Many friends said that they do not know how to remove useless rows from WPS tables in batches. For this reason, the following article introduces the method of removing useless rows from WPS tables in batches. I hope friends in need can learn together.

1. Open the wps worksheet to be edited. As shown in the figure, the rows marked in yellow in the table are the rows to be deleted.

2. Select [Data]-[Auto Filter] in the function bar, as shown in the figure:

3. Move the mouse to column E and click the inverted triangle in the lower right corner, as shown in the figure:

4. In the filter dialog box that pops up, select the common points of the rows you want to delete and check them, as shown in the figure:

5. After clicking the [OK] button, all lines containing [.] will be filtered out, as shown in the figure:

6. The next few steps are to quickly delete the filtered rows.

Ctrl+G key combination to open the [Position] dialog box, select [Visible Cells] in the dialog box, and click the [Position] button. As shown in the picture:

7. In [Positioning] state, the table display status is as shown in the figure:

8. Locate the rows, drag the mouse to select all rows, right-click the mouse button, and click [Delete] to delete the filtered rows.

9. When all filtered rows containing [.] are deleted, there will no longer be rows containing [.] in the table. As shown in the picture:

The above is the method shared by the editor to batch remove useless rows from WPS tables. Let’s learn together. I believe it can help some new users.