Move data between rows and columns in Excel

Posted by on February 16, 2012 Leave a comment (0) Go to comments
  1. Copy the data in one or more columns or rows.
  2. Before you paste the copied data, right-click your first destination cell (the first cell of the row or column into which you want to paste your data), and then click Paste Special.
  3. In the Paste Special dialog box, select Transpose, and then click OK.

You’ll find theTranspose check box in the lower-right corner of the dialog box as shown in the below screenshot.


Share|

Related posts:

  1. Microsoft Excel VLOOKUP function Explained
  2. Microsoft Excel Text functions MID, LEFT, RIGHT
  3. Microsoft Excel If and Nested If function examples
Blog

Leave a Comment