WPS Row and Column Shortcuts on Windows: Introduction

WPS Row and Column Shortcuts is a spreadsheet drag-and-drop helper in WPS Spreadsheet; it includes 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

Row and Column Shortcuts is a built-in helper feature in WPS Spreadsheet on Windows. It shows shortcut buttons near row and column headers so you can drag rows or columns to a new position more quickly. After the feature is turned on, shortcut buttons appear near the selected row or column area, making it easier to move or replace rows and columns directly.

Core tasks include:

Turn on Row and Column Shortcuts from Display Settings in the status bar.
Drag rows or columns to move or replace them, with Shift used for replacement behavior.
Turn off Row and Column Shortcuts to hide the shortcut buttons while keeping worksheet content unchanged.

This feature is useful for reorganizing report layouts, adjusting field order, and rearranging data regions in a worksheet.

System Requirements

Item	Requirement
Operating system	A Windows PC that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	No mandatory internet connection is required for local spreadsheet editing
Other	Open WPS Spreadsheet and enter an editable worksheet

Download & Installation

Before using Row and Column Shortcuts, install WPS Office on your Windows PC and open a spreadsheet file.

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Office, open a spreadsheet file, and check whether the Display Settings entry is available in the lower-right status bar

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In WPS Spreadsheet, you can turn on Row and Column Shortcuts and drag shortcut buttons to move or replace rows and columns.	Excel lets users move or copy rows and columns with commands or mouse drag-and-drop, including Shift or Ctrl combinations for insert or copy behavior.	Google Sheets lets users move rows, columns, or cells, and rows or columns can also be dragged to a new location.	Notion table view supports dragging rows and columns on desktop or in the browser, but it is a database table view rather than spreadsheet-style cell editing.	Adobe Acrobat supports dragging PDF pages to reorder them, but it does not provide spreadsheet row and column editing.
WPS Advantages	Advantage: WPS shows dedicated shortcut buttons directly in the spreadsheet interface; Distinct: once enabled, the feature centers row and column rearrangement around visible header shortcuts.	Compared with WPS: Excel focuses on general drag-and-drop and command-based actions, without a separate Row and Column Shortcuts toggle described on the official page.	Compared with WPS: Google Sheets supports drag-based movement, but the official page does not describe a separate shortcut-button display setting for rows and columns.	Compared with WPS: Notion is designed more for database organization than spreadsheet-style cell calculation workflows.	Compared with WPS: Adobe's related capability is for PDF page organization rather than spreadsheet row and column editing.
Official Source	—	Move or copy rows and columns in Excel	Add or move columns and cells in Google Sheets	Table view in Notion	Organize PDF pages in Acrobat on the web

Overall Conclusion

If your main goal is to rearrange spreadsheet rows and columns quickly, WPS provides a more direct on-screen entry through visible shortcut buttons. Excel and Google Sheets also support moving rows and columns, but their workflows rely more on general drag-and-drop or menu commands. Notion and Adobe are better suited to database organization or PDF page management.

Use Cases

No.	Scenario	Suitable Users	Main Pain Point	Solution
1	Adjusting report field order	Finance teams, administrative staff	Column order needs frequent changes	Turn on Row and Column Shortcuts and drag columns to the target position
2	Reordering grouped data	Data organizers	Row order changes take too many steps	Use the shortcut button to drag rows to a new location
3	Replacing existing row or column content	Advanced spreadsheet users	Replacement is needed instead of insertion	Hold Shift while dragging to replace content
4	Showing shortcut controls only when needed	Everyday office users	Extra controls are not needed all the time	Turn the feature on when needed and turn it off afterward
5	Quickly reorganizing a template sheet	Teachers, students, operations staff	Template fields are not in the needed order	Use Row and Column Shortcuts to rearrange the template structure quickly

Membership & Benefits

Free vs WPS Premium

Row and Column Shortcuts can be used without membership. The WPS pricing page also presents free and paid plans, and paid plans generally include broader advanced services and extended benefits.

Capability	Free Users	WPS Premium
Row and Column Shortcuts	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
More advanced services and extended benefits	Refer to the product page for current availability	Usually includes broader available benefits

Source: WPS Office pricing page

Recommendations

Usage Scenario	Recommended Plan	Reason
Everyday row and column adjustments in spreadsheets	Free	This feature is available directly and does not require membership
Need this feature together with more extended services	WPS Premium	Suitable when you want to use this feature together with broader premium benefits

WPS membership center: Subscribe now