Search code examples
excelcopy-paste

Is there a way to select the transpose option using the keyboard when pasting special in Excel?


I have to do some copy/pasting every now and then and would find it really convenient if I didn't have to use the mouse to select the transpose option manually when pasting values. I know I can transpose only by clicking shift+F10 and then pressing T, but then it copies formulas and not values like I want. Is there any way to paste values and transposing them?

Thankful for any help I can get!

enter image description here


Solution

  • In the paste special menu, the letter underlined in each alternative is the corresponding shortcut key for that alternative. Thanks for pointing that out, @VBasic2008!

    So, for my local verison of Excel (Swedish), I could press N to select the transpose option.