Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Swapping rows and columns
Hey guys,
Is there a quick way to make the spreadsheet rotate so all of the rows are columns and all of the columns are rows? There aren't any formulas on the sheet so references shouldn't be a problem. |
#2
|
|||
|
|||
Swapping rows and columns
Try selecting the cells to rotate, then ctrl+c.
Goto Edit-Paste Special. Select Transpose. Regards, Paul "Dorn" wrote in message ... Hey guys, Is there a quick way to make the spreadsheet rotate so all of the rows are columns and all of the columns are rows? There aren't any formulas on the sheet so references shouldn't be a problem. |
#3
|
|||
|
|||
Swapping rows and columns
Select the data in the worksheet and click the copy button
Move down to an used part of the worksheet; right click in a cell in column A and select Parte Special from the popup menu; click in the Transpose box, click OK Now delete the original data best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Dorn" wrote in message ... Hey guys, Is there a quick way to make the spreadsheet rotate so all of the rows are columns and all of the columns are rows? There aren't any formulas on the sheet so references shouldn't be a problem. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
inserting columns within certain rows only | Excel Discussion (Misc queries) | |||
Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |