2

Is it possible to make this paste option (paste only values with transpose at the same time). As it shown on the schreenshot:

paste only values with transpose

and having one button for this option in drop-down menu here:

excel drop-down menu

PeterH
  • 7,595
XuMuK
  • 415

1 Answers1

3

Thanks User91504, for encouraging me to try MS macrosing.

The working solution has very simple code:

Sub Paste_transpose()
'
' Paste_transpose Macro
'

'
    ActiveCell.Offset.Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=True
End Sub

And there is possibility to add keys combination for this macro - no need to add any buttons anywhere.

XuMuK
  • 415