Not without some programming.

However, using the keyboard instead of the mouse makes it a quick and
*relatively* painless process. Use Ctrl-C to copy the data, move to the new
location and use
Alt-E then S E Enter. Takes less than a second, once you get
accustomed to it.

"SSD1" wrote:

I am collecting data that occurs in columns and want to transpose it to rows.
Can I avoid the "Paste Special/Transpose" route? Is there a way to
automatcially transpose the data every time I paste.

--
SSD1