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

Use Insert/Delete Rows and Columns in WPS on macOS through 4 how-to topics; all 4 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Add rows or columns from the right-click menu

Entry point: Select a row header or column header → right-click menu

1. Click a row number to select the entire row, or click a column letter to select the entire column.
2. Right-click the selected row header or column header.
3. Select Add Row Above, Add Row Below, Add Column Left, or Add Column Right as needed.
4. Check that the new row or column appears in the expected position.

Success Criteria

• Interface result: A new blank row or column appears in the target location.
• Next action available: You can enter data or apply formatting in the new area right away.

Tips While Using

• Common mistake: If only a cell is selected instead of a row header or column header, the menu options may be different.
• Environment note: Make sure the spreadsheet is editable.

2. Delete rows or columns from the right-click menu

Entry point: Select a row header or column header → right-click menu

1. Click the row number or column letter that you want to remove.
2. If needed, select multiple rows or columns for batch deletion.
3. Right-click and choose Delete Row or Delete Column.
4. Confirm that the worksheet structure has updated.

Success Criteria

• Interface result: The selected rows or columns are removed from the worksheet.
• Next action available: Neighboring data shifts into place and you can continue editing.

Tips While Using

• Common mistake: Check the selected range before deleting so you do not remove nearby data by accident.
• Environment note: If the file is read-only, deletion will not be available.

3. Add rows or columns from the Insert tab

Entry point: Insert tab → Rows & Columns

1. Click the position in the worksheet that you want to use as the insertion reference.
2. Open the Insert tab.
3. Click the Rows & Columns button to open the menu.
4. Select Add Row Above, Add Row Below, Add Column Left, or Add Column Right.
5. Check that the new row or column appears where you expect it.

Success Criteria

• Interface result: The worksheet shows the newly added row or column.
• Next action available: You can continue typing, copying, or formatting content.

Tips While Using

• Common mistake: Confirm the current cursor position or selected area before inserting so the new row or column appears in the intended place.

4. Delete the current row or column from the Insert tab

Entry point: Insert tab → Rows & Columns

1. Click the current row or column position that you want to remove.
2. Open the Insert tab.
3. Click the Rows & Columns button.
4. Select Delete Row or Delete Column.
5. Check that the worksheet structure has been updated.

Success Criteria

• Interface result: The current row or column is removed and the worksheet is rearranged.
• Next action available: You can continue inserting other rows or columns or save the file.

Tips While Using

• Common mistake: Confirm the current position before deleting so the correct row or column is removed.