| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
You can try this: Insert a blank sheet. On sheet3, press CTRL+A twice to highlight the entire sheet and press CTRL+C (to copy the sheet) go to your new blank sheet and with cell A1 selected, right click and choose Paste Special... check the Transpose box and click OK Your sheet should now appear rows to columns and columns to rows. Does this work for you? -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=470216 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to keep rows together when sorting columns? | Excel Worksheet Functions | |||
| turn columns into rows | Excel Discussion (Misc queries) | |||
| Inverting rows and columns | Excel Discussion (Misc queries) | |||
| repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) | |||
| interchange columns with rows | Excel Discussion (Misc queries) | |||
Threaded Mode
