In Microsoft Excel, how do I turn a row into a column or vic

Discussion, tips and tricks for the different Windows flavors

In Microsoft Excel, how do I turn a row into a column or vic

Postby curlee » Wed Jul 15, 2009 2:38 pm

In an Excel worksheet, you can use the Paste Special function to cut and paste data from a row to a column or from a column to a row. To do so:

Select the data cells you want to switch. You can select the whole row or column if you wish.


From the Edit menu, select Copy.


Select the upper left cell of the paste area. The paste area must be outside the area containing the data you want to switch. For example, if you are switching data in a column in cells A1 through A5, the paste area cannot overlap with any cells in A1 through A5. One possibility in that case is to use B1 through F1 for the paste area; to do that, you would select cell B1.


From the Edit menu, select Paste Special.


The Paste Special dialog box will open. Check Transpose and then click OK.
curlee
Site Admin
 
Posts: 49
Joined: Wed May 03, 2006 12:01 pm

Return to Windows

Who is online

Users browsing this forum: No registered users and 1 guest

cron