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
October 19, 2021
10.3K
Views
0
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. Resize width of columns and rows in a table
- 2. Collapse or expand rows or columns in a sheet
- 3. Switch between multi-component window management mode and all-in-one mode
- 4. How to Change Columns to Rows in Excel
- 5. How to insert rows and columns in the table
- 6. How to lock columns and rows in a table