|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 26th, 2005, 03:25 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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 -- kgerlitz 
|
|
#2
November 26th, 2005, 06:49 PM
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
November 26th, 2005, 07:11 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Want to see my horizontal and vertical ruler again | Gitte | Page Layout | 3 | October 13th, 2005 06:31 PM |
| How do I restore the vertical and horizontal lines on sheets of la | Alvis | General Discussion | 4 | May 22nd, 2005 03:12 PM |
| Horizontal to vertical text? | sdlfkj | New Users | 6 | April 26th, 2005 05:31 AM |
| auto insert copy of worksheet | Bernie Deitrick | Worksheet Functions | 0 | March 4th, 2004 02:18 PM |
| How do I get the vertical and horizontal lines when I print | linda99 | Worksheet Functions | 5 | January 20th, 2004 01:15 PM |
Linear Mode
