Home  >  Article  >  Topics  >  What should I do if I can’t delete endless blank rows in Excel?

What should I do if I can’t delete endless blank rows in Excel?

藏色散人
藏色散人Original
2021-03-17 14:36:2343459browse

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.

What should I do if I can’t delete endless blank rows in Excel?

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

What should I do if I can’t delete endless blank rows in Excel?

Next we can click on the screen to create a new Excel document

What should I do if I can’t delete endless blank rows in Excel?

Next we enter the data we need in the cell, we click on the first row that needs to be deleted

What should I do if I can’t delete endless blank rows in Excel?

and then Press and hold the "Ctrl Shift Down Arrow" on the keyboard to select all the lines below

What should I do if I can’t delete endless blank rows in Excel?

The last thing we need to do is to right-click and select "Delete" It can solve the problem of deleting endless blank rows

What should I do if I can’t delete endless blank rows in Excel?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn