In this example of the source table there are 4 columns and 6 rows.
We select correctly to the range for transposing. #PASTE TRANSPOSE EXCEL SHORTCUT MAC HOW TO#
But the TRANSPOSE function is still present in Excel, so we will learn how to use it. With the advent of the SPECIAL INSERT, the transposing of the table with using the TRANSPOSE command is almost not used because of the complexity and longer time for the operation. The method 2: the TRANSPOSE function in Excel To do this, you need to select only the array with the values and to do the same with the «Paste Special» command. Similarly, only values can be transposed, without the names of rows and the columns. Now the table header is located vertically (what is clearly visible due to the green color of the header), and the data are respectively located horizontally. The value formula was also copied and counted the product of price and quantity, but already with taking into account other cells. Moreover, we note that cells with the same content are highlighted in green. The rest we left as is and click OK.Īs a result we obtained the same table, but with different arrangement of the rows and the columns.
In the window that appears we put the tick near the TRANSPOSE. We click on the command Paste Special (CTRL+ALT+V). We put the cursor anywhere in the Excel worksheet and right-click the menu. We select the entire table and copy it (CTRL + C). To transpose the table, we will use the SPECIAL INSERT command. We need to arrange the table`s data horizontally relative to the vertical arrangement of its header. For the sake of the clarity, the table header is highlighted in green color. The cost is calculated by the formula: price * quantity. The table cap is located horizontally, and the data is arranged vertically, respectively. We have the table with the price of a certain product per a piece and with certain amount of products. If you have any suggestions or feedback, please comment to us.It`s the simplest and universal way. Hope this article will help you when you need to perform this operation. We showed different ways to Transpose using the Paste shortcut here. Now, put a mark on the Transpose option. From the Paste drop-down select Paste Special. We can apply this Paste Special in different ways. We can also use Paste Special for this Transpose. Excel Paste Special Shortcut Apply to Transpose 
Now, select the Transpose(T) option and we will get the return values at once.Ĥ. From the Context Menu, select the Paste Options. Again, click the right button of the mouse. Then click the right button of the mouse. How to Transpose Columns to Rows In Excel (6 Methods). Transpose Multiple Rows in Group to Columns in Excel. VBA to Transpose Array in Excel (3 Methods). After selecting the Transpose(T), we will get our desired transpose result. From the Paste option, select Transpose(T). 
Now, click the drop-down of the Ctrl menu. First, select the data from the cell range of B4:C9 that we want to transpose. Related Content: How to Transpose in Excel (5 Easy Ways)Ģ. After selecting Transpose(T), we will get our transposed data. From the drop-down of Paste option, select Transpose(T). Now, go to Cell B11 to Paste and Transpose. Now, select Copy from the Clipboard group of commands. We can transpose by using the Ribbon commands. 4 Methods to Transpose Using Excel Paste Shortcut 1.
0 kommentar(er)
