Toolbar command to paste values and transpose them
 

Hi

Does anyone know of a way in Excel 2003 to set-up a toolbar button to paste
values and transpose them? At the moment I'm using ALT e s v e enter but it's
quite slow to use and even slower to use the mouse...

Any ideas much appreciated.

Thanks
Dave

Toolbar command to paste values and transpose them
 

Record a macro while doing the Paste Special operation, give it a meaningful
name such as TransposeValues.
Rather than me regurgitating what's already in the Excel Help file, I'll let
you read it and get the macro assigned to a button:
In Excel Help, search for "start macro from toolbar button" and in the list
of possible topics that appears, choose "Run a Macro". On that page there
are instructions for setting things up to run a macro from a button added to
an existing toolbar group or for creating a new toolbar and adding a button
to it to run the macro.



"bruceleemonkey" wrote:

Hi

Does anyone know of a way in Excel 2003 to set-up a toolbar button to paste
values and transpose them? At the moment I'm using ALT e s v e enter but it's
quite slow to use and even slower to use the mouse...

Any ideas much appreciated.

Thanks
Dave

Toolbar command to paste values and transpose them
 

Thanks for the suggestion, I was hoping there was a way to do it without
using a macro as that prevents you from using the undo function afterwards...

"JLatham" wrote:

Record a macro while doing the Paste Special operation, give it a meaningful
name such as TransposeValues.
Rather than me regurgitating what's already in the Excel Help file, I'll let
you read it and get the macro assigned to a button:
In Excel Help, search for "start macro from toolbar button" and in the list
of possible topics that appears, choose "Run a Macro". On that page there
are instructions for setting things up to run a macro from a button added to
an existing toolbar group or for creating a new toolbar and adding a button
to it to run the macro.



"bruceleemonkey" wrote:

Hi

Does anyone know of a way in Excel 2003 to set-up a toolbar button to paste
values and transpose them? At the moment I'm using ALT e s v e enter but it's
quite slow to use and even slower to use the mouse...

Any ideas much appreciated.

Thanks
Dave

Toolbar command to paste values and transpose them
 

Sorry, I just don't see any way of doing it without a macro.

"bruceleemonkey" wrote:

Thanks for the suggestion, I was hoping there was a way to do it without
using a macro as that prevents you from using the undo function afterwards...

"JLatham" wrote:

Record a macro while doing the Paste Special operation, give it a meaningful
name such as TransposeValues.
Rather than me regurgitating what's already in the Excel Help file, I'll let
you read it and get the macro assigned to a button:
In Excel Help, search for "start macro from toolbar button" and in the list
of possible topics that appears, choose "Run a Macro". On that page there
are instructions for setting things up to run a macro from a button added to
an existing toolbar group or for creating a new toolbar and adding a button
to it to run the macro.



"bruceleemonkey" wrote:

Hi

Does anyone know of a way in Excel 2003 to set-up a toolbar button to paste
values and transpose them? At the moment I'm using ALT e s v e enter but it's
quite slow to use and even slower to use the mouse...

Any ideas much appreciated.

Thanks
Dave