How to delete blank rows of table in batches

Uploaded time: September 27, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

How to delete blank rows of table in batches

How to delete blank rows of table in batches

When we encounter many blank rows in a table, it can be troublesome to delete them one by one. Then how can we accurately delete all the blank rows in batches at once?

_1.gif

We click the Home tab, find the Find and Replace drop-down button under the tab, and choose the Go To option. Or we can use the shortcut key Ctrl+G to open the dialog box.

In the Go To dialog box, check the Blanks option, and then click Go To. We can see that all the blank rows are selected. Click the right mouse button, choose Delete in the pop-up shortcut menu, and then choose to delete Entire Row.

What a practical feature! Make your work easier with WPS Spreadsheet like Microsoft Excel.Did you get it?