WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How to delete blank rows of table in batches

Uploaded time: September 27, 2021 Difficulty Beginner

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?


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?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.