When using WPS Row and Column Shortcuts, common questions usually involve the entry point, drag results, and replacement behavior; this FAQ covers 3 common questions and includes a glossary of key terms.
FAQ
Why can't I find the Row and Column Shortcuts entry?
- Make sure you are working in a WPS Sheets worksheet instead of another WPS component.
- Check whether Display Settings is visible in the lower-right status bar.
- Open Display Settings and look for Row and Column Shortcuts.
- If the interface does not refresh immediately, reopen the spreadsheet and check again.
Why does dragging insert content instead of replacing it?
- Select the row or column that you want to move first.
- Drag it toward the target position and watch the insertion indicator line.
- If you want to replace existing content, hold Shift during the drag.
- Release the mouse and check whether the result matches your expectation.
Will my earlier changes disappear after I turn off Row and Column Shortcuts?
- Turning off Row and Column Shortcuts only hides the shortcut buttons.
- Any completed row or column movement or replacement stays in the current worksheet.
- If you need to adjust the structure again, turn the feature back on and continue editing.
Glossary
| Term | Definition |
|---|---|
| Row and Column Shortcuts | A shortcut control shown near worksheet row or column headers to help you drag and rearrange structure more quickly. |
| Insertion indicator line | A visual line shown during dragging to indicate where the row or column will be inserted. |
| Shift replace | A drag behavior that uses the Shift key so the target content is placed as a replacement instead of a standard insertion. |