Excel table row and column conversion tutorial

In Excel table operations, we often need to convert Excel tables and columns, friends who do not understand this method can learn the Excel row and column conversion tutorial.

Excel skills Excel table row and column conversion tutorial

Step one, select the row area you want to convert to a column

First open the worksheet and select the range of cells you want to move to the column, as shown in the figure:

Step two, copy the selected line contents

Switch to the Start tab, click the Copy button in the Clipboard option group, and copy the selection.

Step three, open the Paste Selective dialog box

Click the starting cell for the range you want to convert and right-click, and select Paste Selective on the pop-up shortcut menu, as shown in the figure:

Step five, view the effect

At this point we can return to the worksheet and we can see that the original row content has been converted to the contents of the column.

Tip: Excel columns are converted to rows

To do this, copy the contents of the column you want to convert, and then use the same method above to "paste" to "transpose" to achieve Excel conversion.

The above is about how Excel transforms the table rows and columns and Excel to convert the row and column method, is not very simple, hoped has the help to you.