Home |
Search |
Today's Posts |
#1
|
|||
|
|||
flip worksheet from horizontal to vertical
How can I flip an entire worksheet and data so that the column headings across the top become vertical on the left side and all the data flips accordingly
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
flip worksheet from horizontal to vertical
Try this: Select the range (cannot be more than 256 rows) EditCopy Switch to Cell A1 on a new worksheet (just to be safe) EditPaste Special Select: Transpose Click the [OK] button Does that help? *********** Regards, Ron "kgerlitz" wrote: How can I flip an entire worksheet and data so that the column headings across the top become vertical on the left side and all the data flips accordingly -- kgerlitz |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
flip worksheet from horizontal to vertical
If you have less than 256 rows you can CopyPaste SpecialTransposeOKEsc
More than 256 rows would require some VBA to manipulate the data. Gord Dibben Excel MVP On Sat, 26 Nov 2005 15:25:02 +0000, kgerlitz wrote: How can I flip an entire worksheet and data so that the column headings across the top become vertical on the left side and all the data flips accordingly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
Excel - turn a page number in a header from horizontal to vertical | Charts and Charting in Excel | |||
How do I get both horizontal and vertical frozen panes in Excell | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Worksheet name and Backward compatibility | Excel Discussion (Misc queries) |