How to Insert or Delete Cells in WPS on Windows

Use Insert/Delete Cell in WPS through 4 how-to topics, including 2 free topics and 2 membership-related items; you can start from the right-click menu or the Home tab.

How-to Index

How-to Guide

1. Right-click Insert Cells

Entry point: Right-click a cell and open the Insert menu

1. Select the cell where you want to insert content.
2. Right-click the cell and choose Insert.
3. Select the insert method you need: shift cells right, shift cells down, insert a row above, insert a row below, insert a column to the left, or insert a column to the right.
4. Check that the worksheet structure has updated as expected.

Success Criteria

• On-screen result: A new cell, row, or column appears in the target position.
• What you can do next: You can continue entering data, formatting cells, or saving the file.

Tips While Using

• Common mistake: If the target position is not selected first, the inserted area may appear in the wrong place.
• Environment note: If the worksheet is protected, some insert actions may be unavailable.

2. Right-click Delete Cells

Entry point: Right-click a cell and open the Delete menu

1. Select the cell that you want to remove.
2. Right-click the cell and choose Delete.
3. Select the delete method you need: shift cells left, shift cells up, delete the entire row, delete the entire column, or delete blank rows.
4. Check whether nearby data has moved into place correctly.

Success Criteria

• On-screen result: The selected area is removed and nearby cells move according to the option you selected.
• What you can do next: You can continue editing, undo the action, or adjust the worksheet again.

Tips While Using

• Common mistake: If you do not confirm the affected range first, nearby data layout may change unexpectedly.
• Membership note: Deleting blank rows is membership-related; other common delete methods are available from the current feature path.
• Environment note: Check important formulas and data ranges before deleting.

3. Insert Cells from the Ribbon

Entry point: Home tab → Rows and Columns menu → Insert Cells menu

1. Select the cell where you want to insert content.
2. Click the Home tab.
3. Open the Rows and Columns menu.
4. Open the Insert Cells menu.
5. Choose to insert a row above, a row below, a column to the left, or a column to the right.

Success Criteria

• On-screen result: The worksheet structure updates immediately after the ribbon command runs.
• What you can do next: You can continue entering data or applying formatting.

Tips While Using

• Common mistake: If the wrong cell is selected first, the inserted position may shift from what you expected.
• Environment note: Ribbon layout can look slightly different depending on window size.

4. Delete Cells from the Ribbon

Entry point: Home tab → Rows and Columns menu → Delete Cells menu

1. Select the cell that you want to remove.
2. Click the Home tab.
3. Open the Rows and Columns menu.
4. Open the Delete Cells menu.
5. Choose Delete Cells, Delete Row, Delete Column, or Delete Blank Rows.

Success Criteria

• On-screen result: The target cell, row, or column is removed.
• What you can do next: You can continue reorganizing data, or press Ctrl + Z to undo if needed.

Tips While Using

• Common mistake: Check the selected range before deleting an entire row or column.
• Membership note: Delete Blank Rows is a membership-related option.
• Environment note: If the worksheet contains important formulas, review reference changes after deletion.