Method 1 – Using Ribbon Paste Shortcut to Transpose in Excel We can transpose by using theRibboncommands. The process is given below: Steps: Select the data we have to transpose. We selected rangeB4:E9. Go toHome. SelectCopyfrom theClipboardgroup of commands. ...
在目标位置上,右键点击并选择“粘贴特殊”(Paste Special)。在弹出的菜单中,找到“转置”(Transpose)选项,并勾选它。最后,点击“确定”即可完成转置操作。 5. 完成转置 (Finish Transposing) 此时,你会看到原数据已经成功转置到新的位置。检查一下数据是否如预期那样正常显示。 Excel转置的快捷键 (Shortcut Keys fo...
Read More:How to Paste Transpose in Excel Using Shortcut (4 Easy Ways) Method 2 – Transposing a Table and Linking It to the Initial Data Steps: Select cells in theB4:I9range. PressCTRL + C. Select cellB11. PressCTRL + ALT + V. Click on thePaste Linkon thePaste Specialwizard. The...
Right-click the cell where you want to paste transposed data (B1), click the arrow next to Paste Special, and choose the Transpose icon (or use the Transpose shortcut). Note: The paste range can’t intersect with the original, copied range. (That’s why this example has data pasted in...
Note:If your data is in an Excel table, the Paste Transpose option will not be available. You should convert the table to a range first by right-clicking on the table, then selectingTable>Convert to Rangefrom the context menu. Step 1: Copy the range to be transposed ...
If you copy and transpose it elsewhere, Excel automatically interchanges rows and columns. Those who reformat tables more often in this way would be better off using a pivot table. To make things a little easier, you can also copy, paste, and transpose by using shortcuts: First, you mark...
Step 4:Right-click using the mouse and choose Paste Special. The keyboard shortcut Ctrl + Alt + V can open the "Paste Special" dialogue box. Now select Transpose. Step 5:Your data is shifted to your provided location. Remember to delete the original data table. ...
Transpose columns and rows with Paste Special function You can use the Paste Special function to transpose columns and rows when paste data in Excel. Please do as follows. 1. Select the range you want to transpose when paste, and then press Ctrl + C keys simultaneously to copy the selected...
Now, right-click and hover on “Paste Special” to see paste special options. From the above options, choose the method as “Transpose.” Click on that, and it will transpose data. The even quicker way is following the shortcut method. After copying the data, we must press the paste sp...
Click ASAP Utilities › Range › 18. Transpose data with formulas... Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...Copy and paste multiple selected ranges at once... Split the selected range into multiple worksh...