How to delete blank rows of table in batches

Uploaded time: September 27, 2021 Difficulty: Primary

How to delete blank rows of table in batches

How to delete blank rows of table in batches

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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.

_2.gif


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.

_3.gif


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