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.
Windows • MacOS • Linux • iOS • Android
How to move rows in a worksheet
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.