How to delete endless rows at the bottom of the table

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.

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

Open the form.

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.

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.

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

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!