Top 3 Products & Services
Dated: Oct. 19, 2009
Related CategoriesComputer Beginners Guides
If we have valuable information or accounting info stored in excel and by chance if you come across a situation where you need to convert the rows to columns. then we can use the transpose functionality in Excel.
It is done with few quick steps:
1. Copy the entire cells in excel from any sheet
2. open the new sheet where you want to paste the details
3. Click on edit->Paste Special or use Alt+E+S as keyboard shortcut and you will get a new window with flooded options. Look for option called transpose and add the check mark to it.
4. Click ok and you will find the values are changed from rows to columns and vice versa.
Now that you've gotten free know-how on this topic, try to grow your skills even faster with online video training. Then finally, put these skills to the test and make a name for yourself by offering these skills to others by becoming a freelancer. There are literally 2000+ new projects that are posted every single freakin' day, no lie!