Home >Topics >excel >How to delete endless rows at the bottom of the table

How to delete endless rows at the bottom of the table

醉折花枝作酒筹
醉折花枝作酒筹Original
2021-05-04 10:14:0341332browse

Delete method: First open the excel table, press "Ctrl Shift Down Arrow Key" to select all subsequent rows; then click "File" - "Edit" - "Clear" at the top of the page Just click "All" and you will see that the endless rows at the bottom of the table have been deleted.

How to delete endless rows at the bottom of the table

The operating environment of this tutorial: windows7 system, WPS Office2016 version, Dell G3 computer.

Open the form.

How to delete endless rows at the bottom of the table

Next, we want to keep the blue table and delete the others. At this time, we need to select the unwanted first row and press Ctrl Shift Down Arrow Press the key to select all the following lines. Press Shift to select the last line.

How to delete endless rows at the bottom of the table

After selecting, find the small triangle above the table, then scroll down to see the edit button, then find the clear button under the editing directory, and click Clear All under Clear.

How to delete endless rows at the bottom of the table

Finally, after we click to clear all, we see that all the items we selected in the table below are gone.

How to delete endless rows at the bottom of the table

Related learning recommendations: excel tutorial

The above is the detailed content of How to delete endless rows at the bottom of the table. 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