If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|