howtogeek at November 7th, 2013 10:25 — #1
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?
miguelkvidal at November 9th, 2013 18:51 — #2
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?
jeorge_kabbi at November 21st, 2013 01:24 — #3
both of you are fantastic.
geek at November 22nd, 2013 09:07 — #4
This topic is now closed. New replies are no longer allowed.