Originally published at: http://www.howtogeek.com/174861/how-to-transpose-rows-and-columns-in-excel-2013/
You’ve setup your worksheet with all your row and column headings and you’ve entered all your data. Then, you discover that it would look better if the rows were the columns and the columns were the rows. How do you accomplish this easily?
Actually, you can use the last icon from the 2nd row to transpose what you copied.
You also can use Ctrl+Alt+V to open the Paste Special dialog box.
Another (longer?) way: ALT, H, V, T
The last method will do the following:
ALT start navigating
H open the Home menu
V open the Paste item
T choose the Transpose option
I use Excel in Portuguese, which have another shortcut key (ALT,C,V,T).
Can anyone confirm if I haven't messed up with any key?
both of you are fantastic.
This topic is now closed. New replies are no longer allowed.