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 switch rows and columns in WPS Spreadsheet
February 13, 2023
15.9K
Views
52
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 Special→ Transpose.
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.
Also Read:
- 1. How to lock columns and rows in a table
- 2. How to Change Columns to Rows in Excel
- 3. Switch between multi-component window management mode and all-in-one mode
- 4. How to insert rows and columns in the table
- 5. Resize width of columns and rows in a table
- 6. Collapse or expand rows or columns in a sheet