Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Aldofabrizi
 
Posts: n/a
Default how do I invert the rows and colums in excel?

Is there an easy way to invert rows and columns in Excel?
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default how do I invert the rows and colums in excel?

Look at EditPaste Special, Transpose

--
Kind regards,

Niek Otten

"Aldofabrizi" wrote in message
...
Is there an easy way to invert rows and columns in Excel?



  #3   Report Post  
bpeltzer
 
Posts: n/a
Default how do I invert the rows and colums in excel?

Select the range you wish to 'invert' and copy. Then Edit Paste Special
and select the Transpose radio button.

--Bruce

"Aldofabrizi" wrote:

Is there an easy way to invert rows and columns in Excel?

Reply
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
Excel - copy subtotal rows only Russ Excel Discussion (Misc queries) 1 September 14th 05 10:50 PM
What is the quickest way to hide a lot of rows and colums ? Stephen Tyrrell Excel Discussion (Misc queries) 2 August 19th 05 08:20 AM
i want my excel colums to be rows peter Excel Worksheet Functions 1 March 29th 05 10:37 PM
How do I name the colums and rows? Cin3 New Users to Excel 5 January 5th 05 11:09 PM
switch colums and rows susanne in new jersey New Users to Excel 1 December 22nd 04 08:39 PM


All times are GMT +1. The time now is 04:19 PM.

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

About Us

"It's about Microsoft Excel"