| |
10-30-2009, 05:10 AM
| |||
| |||
| Excel colums and rows I have a large amount of data on an Excel sheet. It has five rows, with columns running through to column BP. I would like to change this layout by rotating the display so that I have 5 columns and 150 (or whatever the correct number is) of rows. How can I do that? Many thnaks.      |
|
10-30-2009, 05:10 AM
| ||
| |
|
10-30-2009, 05:20 AM
| |||
| |||
| Re: Excel colums and rows Hi Walter, You could copy the data, then use Edit|Paste Special > Transpose. -- Cheers macropod [Microsoft MVP - Word] "Walter Seaton" <WalterSeaton@discussions.microsoft.com> wrote in message news:BE8CEA05-3EF8-45BB-AF5C-FB0A6F4D23EC@microsoft.com... >I have a large amount of data on an Excel sheet. It has five rows, with > columns running through to column BP. > > I would like to change this layout by rotating the display so that I have 5 > columns and 150 (or whatever the correct number is) of rows. > > How can I do that? > > Many thnaks. |
|
10-30-2009, 05:20 AM
| |||
| |||
| Re: Excel colums and rows "Walter Seaton" <WalterSeaton@discussions.microsoft.com> wrote in message news:BE8CEA05-3EF8-45BB-AF5C-FB0A6F4D23EC@microsoft.com... > I have a large amount of data on an Excel sheet. It has five rows, with > columns running through to column BP. > > I would like to change this layout by rotating the display so that I have > 5 > columns and 150 (or whatever the correct number is) of rows. > > How can I do that? > > Many thnaks. Select all the data, copy, paste special-transpose. |
 |
| Bookmarks |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Warez&Games(????) [04934/16218] - "Excel Swap (Reverse) Rows & Columns Software 1.1 .exe" yEnc (1/1) | gn437929 | Windows XP | 0 | 05-21-2009 05:21 AM |
| Excel: 20 rows but need to display only 2 at a time in a chart. | Roshlin | Microsoft Office | 0 | 01-20-2009 08:59 AM |
| Excel: 20 rows but need to display only 2 at a time in a chart. | Roshlin | Microsoft Office | 0 | 12-13-2008 04:00 PM |
| Vista Explorer - Colums Wiidth | ildegardo | Windows Vista | 10 | 05-18-2008 08:00 AM |
| Freeze rows and columns in MS Excel 2007 | Dinesh Krishna | Microsoft Office | 2 | 04-30-2008 12:20 AM |
| New To Technology Questions? | Do You Need Help with Your Computer or Device? | Do You Need Help with this site? |
