How to Insert or Delete Cells in WPS on macOS

Use Insert/Delete Cell through 4 how-to topics in the spreadsheet editor; 4 topics are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Insert cells from the right-click menu

Entry point: Select a cell range → right-click → Insert

1. Select the target cell area where you want to insert new cells.
2. Right-click the selection and choose Insert.
3. Select Shift cells right or Shift cells down.
4. Confirm that nearby data moves in the expected direction.

Success Criteria

• UI state: A new cell is inserted at the selected position, and existing data shifts right or down.
• Next actions: You can continue entering data, formatting the sheet, or saving the file.

Tips While Using

• Common mistakes: If you select an entire row or column by mistake, you may enter row-level or column-level editing instead of cell-level editing.
• Environment limits: You need an editable spreadsheet; protected ranges may block changes.

2. Insert cells from the Insert tab

Entry point: Select a cell → Insert tab → Cell options

1. Select the target cell in the spreadsheet.
2. Click the Insert tab at the top of the window.
3. Open the Cell drop-down menu.
4. Choose the command to insert cells and shift them right or down.

Success Criteria

• UI state: The new cell is inserted and nearby data shifts in the selected direction.
• Next actions: You can continue data entry or review nearby formulas.

Tips While Using

• Common mistakes: If you do not confirm the shift direction first, the new layout may not match your expectation.
• Environment limits: Review nearby formulas or references before making structural changes.

3. Delete cells from the Insert tab

Entry point: Select a cell → Insert tab → Cell options

1. Select the cell that you want to remove.
2. Click the Insert tab and open the Cell drop-down menu.
3. Choose the command to delete the cell and shift nearby cells left or up.
4. Check whether adjacent data fills the gap correctly.

Success Criteria

• UI state: The target cell is removed, and nearby data shifts to fill the empty space.
• Next actions: You can continue reorganizing the sheet and save the updated file.

Tips While Using

• Common mistakes: If you do not confirm the affected area before deleting, local data order may change unexpectedly.
• Environment limits: If formulas depend on the edited area, review references after the deletion.

4. Delete cells from the right-click menu

Entry point: Select a cell range → right-click → Delete

1. Select the target cell area that you want to delete.
2. Right-click the selection and choose Delete.
3. Select the command to shift right-side cells left or lower cells up.
4. Confirm that the sheet layout updates as expected.

Success Criteria

• UI state: The selected cell is removed and nearby data automatically fills the gap.
• Next actions: You can continue editing, undo the action, or save the worksheet.

Tips While Using

• Common mistakes: If the result is not correct, press Command + Z right away to undo it.
• Environment limits: If the worksheet is protected, the delete command may be unavailable.