Excel Paste Transpose Shortcut: 4 Easy Ways to Use

In this article, we will discuss the Transpose option of Excel Paste Shortcut. In Excel, we generally transpose Rows to Columns or vice-versa. We can do this in multiple ways. But in this article, we’ll only use the Paste shortcut while copying data from one region to another.

We take a data set that consists of the names and prices of different fruits.

Data set for Excel Paste Transpose Shortcut


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


4 Methods to Transpose Using Excel Paste Shortcut

1. Transpose Using Ribbon Paste Shortcut

We can transpose by using the Ribbon commands. The process is given below:

Step 1:

  • Select the data we have to transpose. Here I’ve selected range B4:C9.
  • Then go to Home.
  • Now, select Copy from the Clipboard group of commands.

Transpose Using Ribbon Paste Shortcut

Step 2:

  • Now, go to Cell B11 to Paste and Transpose.

Transpose Using Ribbon Paste Shortcut

Step 3:

  • Go to the main Home tab.
  • Then select Paste from the commands.
  • From the drop-down of Paste option, select Transpose(T).

Step 4:

Read More: How to Transpose Array in Excel (3 Simple Ways)


2. Keyboard Shortcut to Transpose in Excel

Step 1:

  • First, select the data from the cell range of B4:C9 that we want to transpose.
  • Now, press Ctrl+C.

Keyboard Shortcut to Transpose in Excel

Step 2:

  • Select Cell B11 to paste the data.
  • Now, press Ctrl+V.

Keyboard Shortcut to Transpose in Excel

Step 3:

  • Now, click the drop-down of the Ctrl menu.
  • From the Paste option, select Transpose(T).

Step 4:

  • After selecting the Transpose(T), we will get our desired transpose result.

Keyboard Shortcut to Transpose in Excel


Similar Readings


3. Transpose by Mouse Shortcut

Step 1:

  • Select the range B4:C9 for transpose.
  • Then click the right button of the mouse. We will find the Context Menu.

Transpose by Mouse Shortcut

Step 2:

  • Select Copy from the Context Menu.

Transpose by Mouse Shortcut

Step 3:

  • Go to Cell B11 to Paste.
  • Again, click the right button of the mouse.
  • From the Context Menu, select the Paste Options.

Transpose by Mouse Shortcut

Step 4:

  • Now, select the Transpose(T) option and we will get the return values at once.

Read More: How to Transpose a Table in Excel (5 Suitable Methods)


4. Excel Paste Special Shortcut Apply to Transpose

We can also use Paste Special for this Transpose. We can apply this Paste Special in different ways.

Step 1:

  • Select the range B4:C9 initially.
  • Then go to the Home tab.
  • Select Copy from the commands.
  • Or press Ctrl+C to copy.

Excel Paste Special Shortcut Apply to Transpose

Step 2:

  • Now, select a cell to paste the data. We select Cell B11 for this.

Excel Paste Special Shortcut Apply to Transpose

Step 3:

  • Now, go to the main Home tab.
  • Go to the Paste from the commands.
  • From the Paste drop-down select Paste Special.
  • Or press Ctrl+Alt+V.

Step 4:

  • We will get a dialog box.
  • Now, put a mark on the Transpose option.
  • Then click OK.

Excel Paste Special Shortcut Apply to Transpose

Step 5:

  • Finally, we will get the return.

Read More: Conditional Transpose in Excel (2 Examples)


Conclusion

We showed different ways to Transpose using the Paste shortcut here. Hope this article will help you when you need to perform this operation. If you have any suggestions or feedback, please comment to us.


Related Articles

Alok

Alok

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo