The solution to the problem that excel cannot delete endless blank rows: First open the WPS software program; then create a new Excel document; then enter the required data in the cells; finally click on the first row to be deleted and hold down Use the "Ctrl Shift Down Arrow" on the keyboard to select all the lines below and delete them.
The operating environment of this tutorial: windows7 system, WPS Office2019 version, Dell G3 computer.
The first step we have to do is to open the WPS software program
Next we can click on the screen to create a new Excel document
Next we enter the data we need in the cell, we click on the first row that needs to be deleted
and then Press and hold the "Ctrl Shift Down Arrow" on the keyboard to select all the lines below
The last thing we need to do is to right-click and select "Delete" It can solve the problem of deleting endless blank rows
Recommended study: "Excel Tutorial"
The above is the detailed content of What should I do if I can’t delete endless blank rows in Excel?. For more information, please follow other related articles on the PHP Chinese website!