# Excel Paste And Transpose Shortcut

Written by

Reviewed by

Last updated on October 18, 2023

*This tutorial will demonstrate the shortcut to transpose text in Excel.*

## Paste & Transpose

In Excel, when data is transposed, the direction of the data is changed. In the example below, the original text that is vertical is transposed to horizontal text.

### Paste & Transpose Shortcut

The shortcuts to Paste and Transpose are as follows:

PC Shortcut:Ctrl+ALT+V>E>Enter

Mac Shortcut:Ctrl+⌘+V>⌘+E>Return

**Remember This Shortcut:**

Ctrl + V is the usual command to Paste. Simply add Alt for Paste Special and use

**E**for Transpos

**e**. Alernatively you can use Alt > E > S > E . Remember, Alt is the command to activate the Ribbon shortcuts. E for Paste,

**S**for

**S**pecial, and

**E**for Transpos

**e**.

We will walk through this below.

### Transposing Text

- Highlight text and copy (
**CTRL + C**) - Click on another cell and press and hold
**CTRL + ALT + V**

This brings up the Paste Special Menu., which contains many options for pasting text.

- Type
**E + Enter**which will check the Transpose option

- Press ENTER and you’ll see your final text transposed horizontally

**Transpose Function**

Another way to transpose data in Excel is by using the TRANSPOSE Function.