How to Insert or Delete Cells in WPS on Windows

Use Insert/Delete Cells with 4 how-to topics, including right-click insertion, ribbon insertion or deletion, right-click deletion, and post-edit review; choose a topic from the index and follow the entry path and steps.

How-to Index

How-to Guide

1. Insert cells from the right-click menu

Entry path: Select cells → Right-click menu → Insert

1. Select the target cell or range where you want to insert cells.
2. Right-click the selection and choose Insert.
3. Select Shift cells right or Shift cells down based on your layout.
4. Confirm that the surrounding data moved in the expected direction.

Success Criteria

• On-screen result: A blank cell appears in the target position.
• You can continue: Existing data shifts right or down, and you can enter new content.

Tips While Using

• Common mistake: If the wrong range is selected, nearby data may become misaligned after insertion.
• Environment note: The worksheet must be editable.

2. Insert or delete cells from the ribbon

Entry path: Select cells → Insert tab → Cells drop-down menu

1. Select the cell you want to adjust.
2. Click the Insert tab on the ribbon.
3. Open the Cells drop-down menu.
4. Choose Insert Cells, Shift Cells Right or Insert Cells, Shift Cells Down.
5. If you want to delete cells, choose Delete Cells, Shift Cells Left or Delete Cells, Shift Cells Up from the same area.

Success Criteria

• On-screen result: The selected command inserts or deletes cells as expected.
• You can continue: You can keep editing nearby cells or enter new data.

Tips While Using

• Common mistake: Insert and delete commands can look similar, so confirm the direction before you apply the command.
• Environment note: The ribbon must display the related commands normally.

3. Delete cells from the right-click menu

Entry path: Select cells → Right-click menu → Delete

1. Select the target cell or range you want to remove.
2. Right-click the selection and choose Delete.
3. Select Delete Cells, Shift Cells Left or Delete Cells, Shift Cells Up.
4. Check whether nearby data filled the gap in the expected direction.

Success Criteria

• On-screen result: The selected cells are removed.
• You can continue: Data on the right or below shifts to fill the space.

Tips While Using

• Common mistake: Deleting the wrong range can affect nearby data layout.
• Environment note: If the worksheet is protected, delete commands may be unavailable.

4. Check results after inserting or deleting cells

Entry path: Review the worksheet after the insert or delete action

1. Check whether the target area still follows the correct data order.
2. Review related formulas, referenced ranges, or summary results.
3. If the result is not what you expected, press Ctrl+Z right away.
4. Choose a more suitable insert or delete direction and try again.

Success Criteria

• On-screen result: The worksheet layout matches your expectation.
• You can continue: Formula results remain usable and you can keep editing or save the file.

Tips While Using

• Common mistake: Skipping a formula check can leave result areas inconsistent.
• Environment note: For complex files, review key areas step by step after the change.