Change horizontal data to vertical and make data clearer
Uploaded time: September 27, 2021 Difficulty Beginner
A free Office suite fully compatible with Microsoft Office


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.
Does this video help you?