Insert/Delete Rows and Columns in WPS on macOS FAQ

When using Insert/Delete Rows and Columns, common questions usually focus on insertion position, recovery after deletion, and data impact; this section covers 3 frequent questions and a glossary.

FAQ

How do I insert multiple rows or columns at a specific position in WPS on macOS?

1. Select the row or column that you want to use as the reference position.
2. Open the row and column insertion action from the right-click menu or the top menu bar.
3. If the current interface supports handling by selected range, first select the number of rows or columns you want to work with and then run the insert action.
4. Check whether the new area appears in the expected position.

Can I recover data after deleting rows or columns?

1. If you just completed the deletion, use Undo immediately.
2. Check whether the worksheet has returned to the state before deletion.
3. If several edits have already been made, continue with available history actions or a backup copy of the file.

Will adding rows or columns affect existing data?

1. After you insert a new row or column at a specific position, the original content in that position and after it shifts accordingly.
2. The original data is usually kept, but its displayed position changes.
3. After insertion, check formulas, merged areas, and formatting to make sure they still work as expected.

Glossary