How to Insert or Delete Rows and Columns in WPS on macOS

Use Insert/Delete Rows and Columns through 4 how-to topics, including right-click insertion, right-click deletion, top menu bar insertion, and batch deletion; use the How-to Index to jump to the task you need.

How-to Index

How-to Guide

1. Insert a row or column from the right-click menu

Feature entry: Select a row header or column label → right-click menu

1. Open the WPS spreadsheet file that you want to edit.
2. Click a row header to select the whole row, or click a column label to select the whole column.
3. Right-click the selected row header or column label.
4. Select Add Row Above or Add Row Below, or select Add Column to Left or Add Column to Right.
5. Confirm that the new row or column appears in the target position.

Success Criteria

• Interface result: A new blank row or column appears in the target area.
• What you can do next: You can continue entering data, applying formatting, or saving the file.

Tips While Using

• Common mistake: If you select only a cell instead of a row header or column label, the right-click menu may be different.
• Environment note: The file must be editable.

2. Delete a row or column from the right-click menu

Feature entry: Select a row header or column label → right-click menu

1. In the worksheet, click the row header or column label that you want to remove.
2. Right-click to open the shortcut menu.
3. Select Delete Row or Delete Column.
4. Check whether nearby data has shifted automatically.

Success Criteria

• Interface result: The selected row or column is removed from the worksheet.
• What you can do next: You can continue editing the remaining data or undo the action.

Tips While Using

• Common mistake: Confirm the selected range before deleting so that nearby data is not removed by mistake.
• Environment note: If the file is protected, the delete option may be unavailable.

3. Insert a row or column from the top menu bar

Feature entry: Insert-related menu → row and column actions

1. In the worksheet, click the position that you want to use as the insertion reference.
2. Open the insert-related entry in the top menu bar.
3. Select the row or column action button or dropdown item.
4. Choose Add Row Above, Add Row Below, Add Column to Left, or Add Column to Right as needed.
5. Return to the worksheet and confirm that the structure has been updated.

Success Criteria

• Interface result: The new row or column appears near the selected reference position.
• What you can do next: You can continue inserting, deleting, or entering content.

Tips While Using

• Common mistake: Confirm the current active cell or selected area before inserting so the new row or column is added in the correct place.

4. Delete multiple rows or columns at once

Feature entry: Select multiple rows or columns → right-click menu

1. Select multiple rows or multiple columns as needed.
2. Right-click the selected area.
3. Select Delete Row or Delete Column.
4. Check whether the worksheet area after deletion matches your expectation.

Success Criteria

• Interface result: The selected rows or columns are removed in one action.
• What you can do next: You can continue editing and saving the remaining worksheet area.

Tips While Using

• Common mistake: Check the number of selected rows or columns before batch deletion.
• Environment note: For important data, save a copy first so recovery is easier later.