Liz,

Copy the macro below into your Personal.xls, then add a custom toolbar button and assign it the
macro.

When you want to transpose a range, copy it, select the destination anchor cell, and press your
custom button.

HTH,
Bernie
MS Excel MVP

Sub PasteTranspose()
If Application.CutCopyMode Then _
Selection.PasteSpecial Transpose:=True
End Sub


"Liz" wrote in message
...
Is it possible to create a button on a toolbar for 'Transpose' to save me
going through 'paste special' each time.