Transpose is a feature and a formula in Excel that helps to transpose the data from rows to columns and vice-versa. If you work with data, you often need to transpose the data from rows to columns or columns to rows, and for this, the best way is to use the transpose keyboard shortcut option.
There are multiple ways to transpose the data but, in this tutorial, we have explained the two ways using the transpose keyboard shortcuts to transpose the data.
Keyboard Shortcut to Transpose the Data in the Excel
The quick keyboard shortcuts to transpose the data as mentioned below:
Alt → H → V → T (Recommended)
Ctrl + Alt + V → E → Enter (For transposing including the formatting of the cell)
Ctrl + Alt + V → E→ V → Enter (For transposing the data in values only)
Steps to Transpose the Data Using Keyboard Shortcut
- First select the data, which you want to transpose and then press the “Ctrl + C” keys to copy the selected data.
- After that, go to the cell, where you want to transpose the copied data, and then press the “Alt → H → V → T” keys in sequence and your data will get pasted as transpose.
- Or, press the “Ctrl + Alt + V” keys and you will get the “Paste Special” dialog box opened.
- Now, press “E” to checkmark the “Transpose” option and then press the “Enter” key. (If you want to transpose the data as values only, press “V” after pressing “E” and then press “Enter”)
￩ Back to Main Page (PDF Cheat Sheet – Keyboard Shortcuts for Excel)