WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android


How to move rows in a worksheet

October 21, 2021

How can move row(s) in WPS Spreadsheet? Here are two options to realize it. The methods could be used for a single row or a continuous row range.

· Option 1: Move a single row by dragging

Select a whole row.

Move the cursor to the edge of the row, until the dragging symbol (+) presents.

Drag the selected row to the target place.

Option 1: Move a single row by dragging

· Option 2: Move a single row by cutting and pasting

Right-click on the row to be moved.

Choose Cut from the dropdown list. (Shortcut key: Ctrl+X)

RIght-click on the target row, and choose Paste in the dropdown list. (Shortcut key: Ctrl+V)

Option 2: Move a single row by cutting and pasting

· Move rows within a continuous range

It is similar to moving rows of a continuous range.

Moving continuous rows

Note that the command could not be used on multiple separated rows.

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy. 

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.