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?

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?