How to switch rows and columns in WPS Spreadsheet

October 19, 2021
392 Views 0

Graphic skills

How to switch rows and columns in WPS Spreadsheet

1. First use mouse to select all table contents.

2. Use the shortcut key CTRL+C to copy cell contents.

How to switch rows and columns in excel1.gif

 

3. Click the sell where we want to put the table.

4. Then right-click Paste Special Transpose.

How to switch rows and columns in excel2.gif

 

Now the horizontal data is changed to vertical. Remember to select the original data and right-click to delete.


This skill could also be used in Microsoft Office Excel and OpenOffice.