How to Use WPS Row and Column Shortcuts on macOS

Use WPS Row and Column Shortcuts through 3 how-to topics, including turning the tool on, moving or replacing rows and columns, and turning the tool off; use the How-to Index to jump to each task, with 3 available without membership and 0 membership-related items.

How-to Index

How-to Guide

1. Turn on Row and Column Shortcuts

Entry: Lower-right status bar → Display Settings → Row and Column Shortcuts

1. Open WPS Sheets and go to the worksheet that you want to edit.
2. Click Display Settings in the lower-right status bar.
3. Find Row and Column Shortcuts in the menu.
4. Select this option. After it is turned on, shortcut buttons appear near rows or columns.

Success Criteria

• Interface result: Shortcut buttons appear near row headers or column headers.
• Next action available: You can select a target row or column and continue dragging it.

Tips While Using

• Common mistake: If you are not in an editable worksheet, the entry or interface change may not be obvious.

2. Move or Replace Rows and Columns Quickly

Entry: The ... shortcut button at the top of a row or column header

1. Select the row or column that you want to move or overwrite.
2. Check for the green ... shortcut button near the top of the selected row or column.
3. Drag the target row or column to the destination. An insertion indicator line appears during the drag.
4. If you want to replace existing content instead of inserting, hold Shift while dragging.
5. Release the mouse and confirm that the row or column has been moved or replaced as expected.

Success Criteria

• Interface result: The target row or column appears in the new position, or replaces content as expected.
• Next action available: You can continue editing, save the file, or adjust other rows and columns.

Tips While Using

• Common mistake: If you do not hold Shift, the action inserts the moved content and shifts the original content.
• Environment note: Row and Column Shortcuts must be turned on before the shortcut button appears.

3. Turn off Row and Column Shortcuts

Entry: Lower-right status bar → Display Settings → Row and Column Shortcuts

1. Click Display Settings in the lower-right status bar.
2. Find Row and Column Shortcuts in the menu.
3. Clear this option.
4. Return to the worksheet and confirm that the shortcut buttons are hidden.

Success Criteria

• Interface result: Shortcut buttons no longer appear near row headers or column headers.
• Next action available: Worksheet content stays unchanged and regular editing remains available.

Tips While Using

• Common mistake: Turning off the feature only hides the shortcut buttons. It does not remove any row or column changes that were already made.