How to switch rows and columns in WPS Spreadsheet
September 14, 2026
24.4K
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 highlight and compare duplicates in two columns in excel
- 2. How to insert multiple rows in Excel
- 3. How to add a title in excel spreadsheet 2016
- 4. A12-How to Make a Spreadsheet for Bills in WPS Office (A Step-by-Step Guide)
- 5. How to Press Enter in WPS Spreadsheet [Step-by-Step Guide]
- 6. How to delete the check box in WPS Spreadsheet
15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.
