Excel2010 table row and column conversion graphic tutorial

Excel2010 is a very easy to use office software, then how to convert Excel2010 table rows and columns? Let’s take a look!

Step 1. Select the row area that needs to be converted to a column

First open the corresponding worksheet and select the row cell area that needs to be converted to a column, as shown:

Step 2, copy the selected line contents

Switch to the “Start” folder and click the “Copy” button in the “Clipboard” option group to copy the selection.

Step 3: Open “Select Paste & rdquo; Dialog Box

Click on the starting cell of the area to be converted and right click on the shortcut menu that pops up Select the "Select Paste" command as shown below:

Step 4, View the effect

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

Tip: Convert Excel columns to rows

As with the operation method, copy the contents of the column to be converted first, and then use the same method as above to "select paste" ; Carry out "transposition" to achieve Excel conversion.