How to delete redundant tables in the table

Method: 1. Select the specified row or column, right-click the mouse and select "Delete". 2. Select the specified data, use the "Ctrl G" key, select "Null Value" in the pop-up dialog box, right-click the mouse and select "Delete" - "Entire Row". 3. Select the specified data, right-click the mouse and select "Delete" - "Move the cell on the right to the left or the cell below to move up".

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

The first case, delete a single row or column

Click the row or column label in front of the row or column , select the row or column that needs to be deleted, right-click the mouse and select Delete.

## In the second case, delete multiple rows or columns

Select to delete For a blank data area, use the Ctrl G shortcut key, select a null value in the pop-up dialog box, and click OK.

After selecting all the spaces, right-click the mouse, select Delete, and delete rows to delete the blank cells.

The third case, delete some cells

Drag the mouse to select the cells that need to be deleted, and click the right mouse button. Select Delete and move the cell on the right to the left or the cell below to move up.

After completion, you can see that the selected cells have been deleted.

Related learning recommendations:

excel tutorial

The above is the detailed content of How to delete redundant tables in the table. For more information, please follow other related articles on the PHP Chinese website!