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

Improve this question
4
  • 2
    you could create a macro that would do it in your personal workbook, then create a button for it in the ribbon that fires that macro
    – PeterH
    Commented Oct 16, 2017 at 11:54
  • @User91504 Yes, I could, but I have zero experience (or only negative) with MS office macros. And this will be working only in one document or it is possible to make working in all excel documents?
    – XuMuK
    Commented Oct 16, 2017 at 14:20
  • yeah you can do it accross any work sheet, i dont havfe excel 2016 so i cant make the macro for you, but google how to record a macro, you dont need to write it
    – PeterH
    Commented Oct 16, 2017 at 14:21
  • @User91504 yes! it is much easier than I have experienced before (and also it is working).
    – XuMuK
    Commented Oct 16, 2017 at 15:15

1 Answer 1

Reset to default
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.

Improve this answer
2

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .