WPS Sheets Insert Cell Feature Guide

Feature Summary

Insert cells allows you to add new cells at a specified location. Choose to shift existing cells right or down based on your layout needs, keeping the table structure intact.

Feature Description

Operation Steps

Right-Click Menu Insert Cells

Feature Entry
Select cells → Right-click menu → "Insert" dropdown menu

1. Select the target area where you want to insert cells
2. Right-click and select "Insert" from the menu
3. Choose an insertion method:

• "Shift cells right": New cells are inserted at the current position, and existing data shifts to the right as a whole
• "Shift cells down": New cells are inserted at the current position, and existing data shifts downward as a whole

Ribbon Insert Cells

Feature Entry
Select cells → "Insert" tab → "Cells" dropdown menu

1. Select a cell
2. Click the Insert tab on the ribbon, and select the "Cells" dropdown menu
3. Choose an insertion method:

• "Insert cells, shift cells right": New cells are inserted at the current position, and existing data shifts to the right as a whole
• "Insert cells, shift cells down": New cells are inserted at the current position, and existing data shifts downward as a whole
• "Delete cells, shift cells left": Delete the current cell, and cells to the right shift left
• "Delete cells, shift cells up": Delete the current cell, and cells below shift up

FAQ

Q1: What should I do if data becomes misaligned after inserting cells?

• Solution: Immediately press Ctrl+Z (Mac: Cmd+Z) to undo the operation, and re-select the correct insertion method.

Q2: Why doesn't the options dialog pop up when inserting?

• Solution: The options dialog only appears when you right-click to insert while a cell (rather than an entire row/column) is selected. If an entire row/column is selected, the right-click menu will only show options to add rows/columns.

Notes

• When inserting entire rows/columns, selecting the row numbers/column letters is more efficient than selecting individual cells
• Insert operations can affect formula references; verify that formulas are correct after insertion