LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Reverse a spreadsheet reversing columns and rows?

Copy the range of Data.

Select a cell that will not be overwritten well away from that range or insert a
new sheet.

EditPasteSpecialTransposeOKEsc


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 10:34:02 -0700, Becca
wrote:

I have a spreadsheet witn 30 columns and 15 rows with data and want to flip
it so that the columns become the rows and vice versa.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to reverse order of rows and columns Johnny Excel Discussion (Misc queries) 3 September 11th 05 03:42 PM
reverse columns and rows Teri from Florida Excel Discussion (Misc queries) 1 August 12th 05 04:08 PM
How do I get to print my spreadsheet (8 columns x 100 rows) on an. Bruce Michael Excel Discussion (Misc queries) 2 April 25th 05 05:40 AM
How do I limit number of rows and columns on a spreadsheet Valser New Users to Excel 3 February 12th 05 10:31 PM
Using PROPER for Columns, rows or ENTIRE spreadsheet Tom Excel Worksheet Functions 3 February 4th 05 03:43 PM


All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"