How to Insert or Delete Cells in WPS on macOS

Use insert or delete cells in WPS on macOS through 4 how-to topics, including right-click insert, right-click delete, ribbon insert, and ribbon delete; 2 are available without membership and 2 are membership-related.

How-to Index

How-to Guide

1. Insert cells from the right-click menu

Entry path: Select a cell → Right-click → Insert

1. Select the cell where you want to insert content.
2. Right-click the cell to open the Insert menu.
3. Choose the action you need: insert cells and shift right, insert cells and shift down, insert a row above, insert a row below, insert a column to the left, or insert a column to the right.
4. Check whether nearby data moved as expected.

Success Check

• On-screen result: A new cell, row, or column appears in the selected area.
• Next action: You can continue entering data, formatting the sheet, or undoing the action.

Notes

• Common mistake: If you do not select the target cell first, the insertion point may not match your expectation.
• Limitation: If the worksheet is read-only, insertion is unavailable.

2. Delete cells from the right-click menu

Entry path: Select a cell → Right-click → Delete

1. Select the cell or range that you want to remove.
2. Right-click the selection to open the Delete menu.
3. Choose the action you need: shift cells left, shift cells up, delete the entire row, or delete the entire column.
4. To clean blank rows, use Delete Blank Rows when multiple rows are selected.

Success Check

• On-screen result: The target cells, rows, or columns are removed and nearby data fills the space automatically.
• Next action: You can continue editing the worksheet or use Undo to restore the previous state.

Notes

• Common mistake: If the selection is not confirmed before deletion, nearby data structure may be affected.
• Access note: Delete Blank Rows is membership-related and requires sign-in with eligible benefits.

3. Insert cells from the ribbon

Entry path: Home → Rows and Columns → Insert Cells

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

Success Check

• On-screen result: The worksheet structure updates immediately after the ribbon command runs.
• Next action: You can continue inserting more rows or columns or enter new content.

Notes

• Common mistake: If you confuse Insert Cells with other row or column commands, the result may differ.
• Limitation: In a narrow window, some ribbon buttons may appear inside a drop-down menu.

4. Delete cells from the ribbon

Entry path: Home → Rows and Columns → Delete Cells

1. Select the cell, row, or column that you want to remove.
2. Click the Home tab.
3. Open the Rows and Columns menu.
4. Click the Delete Cells drop-down menu.
5. Choose Delete Cells, Delete Row, or Delete Column; to clean blank rows, use Delete Blank Rows.

Success Check

• On-screen result: The selected content is removed and the worksheet structure adjusts at the same time.
• Next action: You can continue reorganizing the worksheet or use Undo to restore the original state.

Notes

• Common mistake: If you do not confirm the range before deleting an entire row or column, a larger data area may be affected.
• Access note: Delete Blank Rows is membership-related.