This blog is about Microsoft Excel and includes tutorial videos demonstrating how to get things done easily using Excel. And this blog also proves you that Microsoft Excel simply is the best part of Microsoft Office and maybe the most powerful software ever made.
Tuesday 29 January 2013
How to transpose Excel table using Paste Special -feature
There is a handy way to transpose entire table:
Select the table you want to transpose
Select Copy
Select Paste Special (e.g. from the context menu)
Mark checkmark to Transpose --> And vóila, you have transposed table!
No comments:
Post a Comment