WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

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

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

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?

_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?

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