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


Change horizontal data to vertical and make data clearer

Uploaded time: September 27, 2021 Difficulty Beginner

Change horizontal data to vertical and make data clearer

Change horizontal data to vertical and make data clearer

In our daily work, we may encounter some table data with a vertical layout. Using the proper layout style for different tables will make it more convenient for us to check data. So how can we change horizontal data to vertical?

1. First, we use the shortcut key Ctrl+A to select all the contents in the table.

2. Then use Ctrl+C to copy the selected cell range.

3. Right-click and select the Paste Special option.

4. Select Transpose in the popup menu. Then the horizontal data will immediately be converted to vertical.

5. At this time, select the original data row and right-click to delete it.

The converted vertical data is not adjusted to the appropriate column width. We can select columns A to C and double-click the intersection of the column labels. Then WPS Spreadsheet will automatically adjust the proper column width for us.

What a practical skill! Did you get it?

This skill could be also 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.