How to Insert Cells in WPS for macOS

Use Insert Cells in WPS for macOS through 2 how-to topics, both available without membership; choose a topic from the How-to Index and follow the matching entry path.

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 area where you want to insert cells.
2. Right-click and choose Insert.
3. Choose an insertion method:
   1. Shift active cells right to insert new cells at the current position and move existing data to the right.
   2. Shift active cells down to insert new cells at the current position and move existing data downward.
4. Check the worksheet to confirm that blank cells were inserted in the expected location.

Success Criteria

• Visual result: New blank cells appear in the target position.
• Next action available: You can type into the new cells or continue editing nearby data.
• No unwanted change: Other unselected areas are not turned into full inserted rows or columns.

Tips While Using

• Common mistake: If you select a full row or column by mistake, you may insert a row or column instead of cells.
• Data check: After insertion, confirm that nearby data moved in the expected direction.
• Formula check: If formulas are near the target area, review their references after the change.

2. Insert cells from the toolbar

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

1. Select the target cell in the worksheet.
2. Click the Insert tab at the top of the window.
3. Open the Cells drop-down menu.
4. Choose the insertion method you need:
   1. Insert cells, shift active cells right.
   2. Insert cells, shift active cells down.
5. Confirm that worksheet data moved in the selected direction.

Success Criteria

• Visual result: A blank cell appears at the current selection position after insertion.
• Next action available: You can continue with typing, formatting, or later deletion tasks.
• No unwanted change: The worksheet remains controlled, with movement limited to the target area.

Tips While Using

• Common mistake: If you do not select the target cell first, the insertion position may be unclear.
• Menu difference: The drop-down may also include delete-cell commands, so confirm the command name before clicking.
• Data check: Review the layout and any formula references after the action.