Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I rotate a worksheet in Excel?
I know that it is possible to rotate content within a cell, but what if I
want to rotate the whole worksheet? And yes, I know that I could just set it to landscape mode, but I want to modify it once the rows become columns and the columns become rows. |
#2
|
|||
|
|||
You are limited to 256 columns (and therefore 256 rows).
create a new worksheet Select your range on the original worksheet edit|copy go to A1 of the new worksheet edit|paste special|check transpose. MarkRulesTheWorld wrote: I know that it is possible to rotate content within a cell, but what if I want to rotate the whole worksheet? And yes, I know that I could just set it to landscape mode, but I want to modify it once the rows become columns and the columns become rows. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel shifts to wrong worksheet automatically | Excel Worksheet Functions | |||
create menus in excel worksheet | Excel Worksheet Functions | |||
How do I replace a worksheet with another worksheet in excel | Excel Worksheet Functions |