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

Last updated:July 20, 2026

Use Insert/Delete Rows and Columns with 2 how-to topics, including right-click menu actions and top menu actions; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership Requirement
11. Right-click menu actionsFree
22. Top menu actionsFree

How-to Guide

1. Right-click menu actions

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

  1. Click a row number to select the full row, or click a column letter to select the full column.
  2. Right-click the selected row header or column header.
  3. Choose the action you need:
    • Insert Row Above or Insert Row Below
    • Insert Column Left or Insert Column Right
    • Delete Row or Delete Column
  4. To delete multiple rows or columns, select several rows or columns first and then run the delete command.

Success Criteria

  • On-screen result: A new row or column appears in the target position, or the selected row or column is removed.
  • What you can do next: Continue entering data, adjusting formatting, or using Undo.

Tips While Using

  • Common mistake: If you select only a cell instead of a full row or full column, the menu options may be different.
  • Environment note: Check the selection carefully before deleting to avoid removing needed data.

2. Top menu actions

Entry: Insert tab → Rows and Columns button

  1. Click the position you want to use as the reference point for insertion or deletion.
  2. Open the Insert tab.
  3. Click the Rows and Columns button to open the drop-down menu.
  4. Choose the command you need:
    • Insert Row Above or Insert Row Below
    • Insert Column Left or Insert Column Right
    • Delete Row or Delete Column

Success Criteria

  • On-screen result: Rows or columns are inserted or deleted at the selected position.
  • What you can do next: Continue editing nearby data, and existing content shifts to fit the new layout.

Tips While Using

  • Common mistake: If you do not place the cursor in the intended area first, the insertion position may not match your expectation.
  • Environment note: If the file is read-only, worksheet structure changes may not be available.