SelectPastefrom the commands. From the drop-down ofPasteoption,selectTranspose(T). After selectingTranspose(T), we will get ourtransposed data. Method 2 – Using Keyboard Shortcut to Paste Transpose in Excel Steps: Select the data from the cell range ofB4:E9that we want to transpose. Press...
Shortcuts to open the Paste Special dialog box in Excel for Windows areAlt + E + SorCtrl + Alt + V.The Paste Special shortcut in Excel for Mac isCtrl + Cmd + V. Furthermore, if you want to directly copy-paste values or formats, you can use their respective paste special shortcut ...