How to move rows in a worksheet

October 21, 2021
238 Views 0

Graphic skills

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.

(Relevant tutorial: How to move columns in a worksheet)

 

· 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.

How to move rows in a worksheet 1.gif

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)

How to move rows in a worksheet 2.gif

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.

How to move rows in a worksheet 3.gif

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. (Relevant tutorial: How to move columns in a worksheet)