Paste Transpose Shortcut in Excel - Compute Expert

Paste Transpose Shortcut in Excel


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> Paste Transpose Shortcut in Excel





From this tutorial, you will know what is the paste transpose shortcut in excel and how to use the shortcut properly.

When we work in excel, we might sometimes need to copy and transpose our data. This can be done much faster if we do it by using a shortcut. Thus, we might want to know what is the shortcut to paste and transpose our data in excel.

Want to know that and the steps to use the shortcut properly in excel? Let’s get into it.

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more







Paste Transpose Shortcut in Excel

The shortcut to paste transpose in excel is to press Ctrl + Alt + V on your keyboard simultaneously, press E, and then press Enter. Alternatively, you can also use the ribbon shortcut by pressing Alt, H, V, and T buttons in sequence.

In Mac, the paste transpose shortcut in excel is to press Command + Option + V on your keyboard simultaneously, press E, and then press Return. You cannot use the ribbon shortcut to do it as there is no excel ribbon shortcut on Mac.



Steps to Use the Paste Transpose Shortcut in Excel

Here are the complete steps to use the paste transpose shortcut in excel.

  1. Highlight the cell range in which data you want to copy

    Paste Transpose Shortcut in Excel - Screenshot of Step 1

  2. Right-click on the highlighted cell range and choose Copy or Cut. Alternatively, you can just press Ctrl + C (Copy) or Ctrl + X (Cut)

    Paste Transpose Shortcut in Excel - Screenshot of Step 2

  3. Select the cell where you want to put the transposed copied data

    Paste Transpose Shortcut in Excel - Screenshot of Step 3

  4. Execute the paste transpose shortcut (as discussed in the previous section)
  5. Done!

    Paste Transpose Shortcut in Excel - Screenshot of Step 5




Additional Note

Cutting and transposing your data can make the formulas that refer to them produce errors because they lose their original references. Be careful when you do it.



Related excel tutorials you might want to learn from too:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!





Learn Excel Dashboard Course

Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!




Follow our tutorial content also on


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

Recommended Work Tools

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2022 Compute Expert