Change horizontal data to vertical and make data clearer

Uploaded time: September 27, 2021 Difficulty: Primary

Change horizontal data to vertical and make data clearer

Change horizontal data to vertical and make data clearer

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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.

_1.gif

 

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.

_2.gif

 

What a practical skill! Did you get it?

This skill could be also used in Microsoft Office Excel and Openoffice.