WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to switch rows and columns in WPS Spreadsheet

February 13, 2023
15.9K Views

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.