Common questions about Row and Column Shortcuts usually involve where to find the entry, how drag-and-drop behaves, and how replacement works; this section includes 3 FAQs and a glossary.
FAQ
Why can’t I find the Row and Column Shortcuts entry?
- Make sure you are working in a WPS Spreadsheet worksheet.
- Check whether the status bar is visible in the lower-right corner of the window.
- Open Display Settings and look for Row and Column Shortcuts.
- If the entry still does not appear, update WPS Office and try again.
Why didn’t dragging replace the original content?
- Select the row or column that you want to move first.
- Drag it to the target position and check whether the insertion indicator line appears.
- If you want replacement behavior, hold Shift during the drag.
- Release the mouse and confirm whether the result matches the replacement you expected.
Will my changes disappear after I turn off Row and Column Shortcuts?
- No. Turning off the feature only hides the quick action button.
- Rows and columns that were already moved or replaced stay in the worksheet.
- If you need to adjust them again, turn Row and Column Shortcuts back on and continue editing.
Glossary
| Term | Definition |
|---|---|
| Row and Column Shortcuts | A WPS spreadsheet feature that shows quick action controls near rows and columns so you can drag them more efficiently. |
| Display Settings | A status bar entry that controls certain interface display options in WPS Spreadsheet. |
| Replace | A drag-and-drop result triggered by holding Shift so the moved row or column overwrites existing content at the target location. |