Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | Reversing colums and rows
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

Reversing colums and rows

Sometimes you need to change the your Microsoft Office Excel sheet by reversing or transposing it.

 
  Author: mat | Version: CS5 | 16th October 2011 |  
 
 
1.
 

Open the sheet you want to transpose.

 
 
2.
 

Select all cells of your sheet.

 
 
3.
 

Right click the sheet and choose Copy.

 
 
4.
 

Now select an empty cell, right click it and choose Paste Special.

 
 
5.
 

Check the Transpose option and click OK.

 
 
6.
 

The sheet is now reversed!

 
 
 
   
  Please login to post a comment
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO