WPS Row and Column Shortcuts on macOS: Introduction

WPS Row and Column Shortcuts is a spreadsheet editing feature in WPS Sheets for macOS; 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 feature in WPS Office for Mac and WPS Sheets that helps you show row and column action entry points more quickly in a worksheet and rearrange positions by dragging. After you turn it on, shortcut buttons appear near rows or columns so you can move or replace the target row or column directly.

Core tasks include:

Turn on Row and Column Shortcuts: Enable the feature from Display Settings in the status bar.
Move or replace rows and columns by dragging: Drag with the shortcut button to a target position, and hold Shift to replace existing content.
Turn off Row and Column Shortcuts: Clear the option to hide the shortcut buttons.

This feature is useful when you need to reorganize spreadsheet structure, adjust column order, or quickly rearrange worksheet content. It also fits search intent such as how to move rows and columns in a spreadsheet on Mac.

System Requirements

Item	Requirement
OS	A macOS device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	Local spreadsheet editing does not require a network connection; downloading, installation, and account-related services require internet access
Other	You need to open an editable worksheet in WPS Sheets

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Launch WPS Office for Mac, open a spreadsheet file, and check whether the Display Settings entry is visible in the lower-right status bar

Source: WPS download center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides shortcut buttons for rows and columns in a spreadsheet, can be turned on from the status bar, and supports dragging rows or columns. Holding Shift replaces existing content.	Microsoft Word supports moving an entire table and adjusting row height or column width, but the official page does not describe a spreadsheet-style shortcut entry for rows and columns.	Google Sheets supports adding, moving, and deleting rows and columns, and it also lets you drag rows or columns to a new location.	Notion supports drag-and-drop reordering in database views and property display order, but the official page describes database and calendar view organization rather than spreadsheet row and column shortcuts.	Adobe Acrobat supports moving or copying PDF pages for page organization, not worksheet row or column editing.
WPS Advantages	Advantage: The shortcut entry stays inside the spreadsheet interface after you enable it. Distinct: Holding Shift during dragging lets you replace original content while reorganizing a worksheet.	Compared with WPS: Microsoft's official page focuses on moving a whole table or resizing table structure, not on a dedicated row-and-column shortcut toggle inside a spreadsheet.	Compared with WPS: Google Sheets also supports dragging rows and columns, but its official guidance focuses on menu commands or direct dragging rather than a separate display toggle for shortcut buttons.	Compared with WPS: Notion is better aligned with database view arrangement, not traditional worksheet row and column editing.	Compared with WPS: Adobe Acrobat page movement is designed for PDF page management rather than spreadsheet structure editing.
Official Source	—	Move or copy a table	Add or move columns & cells	Calendar view	Move or copy pages within PDFs

Overall Conclusion

If your main goal is to quickly rearrange rows and columns inside a spreadsheet, WPS Row and Column Shortcuts is closer to that worksheet workflow. Other products also support moving content, but the object being moved may be a whole table, a database card, or a PDF page instead of spreadsheet rows and columns.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Reordering columns	Data organizers	Column order needs frequent adjustment	Turn on Row and Column Shortcuts and drag a column to the target position
2	Replacing existing row or column content	Spreadsheet maintainers	New content needs to overwrite data in the original position	Hold Shift while dragging to replace content
3	Hiding shortcut entries temporarily	Light editors	Shortcut buttons do not need to stay visible all the time	Clear Row and Column Shortcuts in Display Settings
4	Reorganizing report structure quickly	Office users	Manual cut-and-paste takes too many steps	Use shortcut buttons to move rows or columns directly
5	Adjusting worksheet layout before presenting	Teachers and students	The worksheet order needs quick cleanup before display	Drag rows or columns to rearrange positions quickly

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
Row and Column Shortcuts	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
More advanced office and PDF capabilities	Some features are limited	More advanced features and higher quotas are available
Cloud storage	1 GB	20 GB

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Daily use of Row and Column Shortcuts and basic spreadsheet editing	Free	This feature itself does not require membership and works well for routine worksheet organization
Additional advanced office, PDF, or larger cloud storage needs	WPS Member	Suitable for users who need broader features and more storage

WPS membership center: Subscribe now