Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)
Transpose is a feature 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
For Windows: Alt → H → V → T
Ctrl + Alt + V and then, E → Enter (for transposing including the formatting of the cell). Ctrl + Alt + V and then, E → V → Enter (For transposing the data in values only)
For Mac: Cmd + Option + V → E
How to use Transpose Keyboard Shortcut in Excel
- 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”)
Great tips on using the transpose feature in Excel! I didn’t realize how easy it was to switch rows and columns with just a keyboard shortcut. This will definitely save me time in my data analysis. Thanks for sharing!
Great tip! I never knew the transpose feature could save me so much time. Can’t wait to try it out on my next project!