How to Use WPS Row and Column Shortcuts on Windows

Use Row and Column Shortcuts through 3 how-to topics: turn the feature on, move or replace rows and columns quickly, and turn the feature off; all 3 topics are available without membership and 0 are membership-related.

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. Click Display Settings in the lower-right status bar of WPS Spreadsheet.
2. Find Row and Column Shortcuts in the menu that appears.
3. Select this option.
4. Check the worksheet area and confirm that shortcut buttons now appear near rows or columns.

Success Criteria

• Interface result: Shortcut buttons appear near row headers or column headers.
• What you can do next: You can continue dragging target rows or columns.

Tips While Using

• Common mistake: If you are not in an editable spreadsheet view, the entry may not appear.

2. Move or Replace Rows and Columns Quickly

Entry: Shortcut button near the row or column header

1. Select the row or column that you want to move or replace.
2. Find the green shortcut button with an ellipsis near the top of the selected row or column area.
3. Hold the button and drag it to the target position.
4. Watch for the insertion indicator line at the destination.
5. If you want to replace existing content, hold Shift while dragging.
6. Release the mouse to complete the move or replacement.

Success Criteria

• Interface result: The target row or column moves to the new position, or replaces content when Shift is used.
• What you can do next: You can continue editing, save the file, or adjust other rows and columns.

Tips While Using

• Common mistake: If Shift is not pressed, the action inserts the moved row or column instead of replacing existing 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 again in the lower-right status bar.
2. Clear Row and Column Shortcuts in the menu.
3. 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.
• What you can do next: The worksheet remains editable in the normal way.
• No side effect: Completed row and column changes are kept.

Tips While Using

• Common mistake: Turning off the feature only hides the shortcut buttons. It does not remove rows or columns that were already adjusted.