How to switch rows and columns in WPS Spreadsheet

October 19, 2021
8.0K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download
Free download

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.

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

4. Then right-clickPaste SpecialTranspose.

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.