I have set my "Insert" key as a keyboard shortcut to "paste" in Word 2007 and
would like to do the same in Excel 2007, but I can't find where to access
anything that allows me to create my own keyboard shortcuts. Anyone got any
ideas?
I have to add that Microsoft have done an excellent job at hiding and
re-naming most of the everyday functions I used to use in Office 2003, I've
gone from a reasonably proficient expert to a complete and utter know-nothing
novice overnight and Microsoft's built in "help" only sems to tell me what I
already know, but not where they've hidden the button or what it's called
now!

You might find these useful:

*
http://office.microsoft.com/training...RC100620751033
(Free online training for using the Ribbon and Fluent interface)
* http://office.microsoft.com/en-us/he...491511033.aspx (Free
interactive tool to help you find where that 2003 command went in 2007)

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com



"Andrew Ball" <Andrew (E-Mail Removed)> wrote in message
news74A5D07-F4F4-4910-A495-(E-Mail Removed):

> I have set my "Insert" key as a keyboard shortcut to "paste" in Word 2007 and
> would like to do the same in Excel 2007, but I can't find where to access
> anything that allows me to create my own keyboard shortcuts. Anyone got any
> ideas?
> I have to add that Microsoft have done an excellent job at hiding and
> re-naming most of the everyday functions I used to use in Office 2003, I've
> gone from a reasonably proficient expert to a complete and utter know-nothing
> novice overnight and Microsoft's built in "help" only sems to tell me what I
> already know, but not where they've hidden the button or what it's called
> now!

Ben,
Thanks for the help, I've downloaded the guides on the weblinks you provided
as they will help with loads of things, but unfortunately I couldn't find
how to assign my own shortcut keys in there.

Andrew

"Ben M. Schorr - MVP (OneNote)" wrote:

> You might find these useful:
>
> *
> http://office.microsoft.com/training...RC100620751033
> (Free online training for using the Ribbon and Fluent interface)
> * http://office.microsoft.com/en-us/he...491511033.aspx (Free
> interactive tool to help you find where that 2003 command went in 2007)
>
> --
> -Ben-
> Ben M. Schorr, MVP
> Roland Schorr & Tower
> http://www.rolandschorr.com
> http://www.officeforlawyers.com
>
>
>
> "Andrew Ball" <Andrew (E-Mail Removed)> wrote in message
> news74A5D07-F4F4-4910-A495-(E-Mail Removed):
>
> > I have set my "Insert" key as a keyboard shortcut to "paste" in Word 2007 and
> > would like to do the same in Excel 2007, but I can't find where to access
> > anything that allows me to create my own keyboard shortcuts. Anyone got any
> > ideas?
> > I have to add that Microsoft have done an excellent job at hiding and
> > re-naming most of the everyday functions I used to use in Office 2003, I've
> > gone from a reasonably proficient expert to a complete and utter know-nothing
> > novice overnight and Microsoft's built in "help" only sems to tell me what I
> > already know, but not where they've hidden the button or what it's called
> > now!
>
>

First enter the following code into a module of your workbook (or a
module in your Personal.xls to have available to all workbooks):


Sub AssignInsertKey()
Application.OnKey "{INSERT}", "Paste"
End Sub


Sub Paste()
ActiveSheet.Paste
End Sub


Now run just the AssignInsertKey macro. (The AssignInsertKey macro
will automatically initiate the Paste macro.)

Now whenever you do a Copy, all you have to do is hit the Insert Key,
and whatever you copied will be pasted into whatever cell you're in
when you hit Insert

Just a couple of additional thoughts...

While I know that you want to use just the single key of Insert to
Paste, the standard 2-key shortcut of Ctrl+V works very nicely in all
Windows applications, and 2 keys isn't really such a hardship.

However, if you really like utilizing the Insert key, note that
without any programming whatsoever, Shift+Insert (while not as
commonly known as Ctrl+V) is also built into Windows as a 2-key Paste
shortcut.

Thanks, I had a go, but I think its beyond me, I kept getting error messages,
I'm not really into programming at the level you seem to be so I'm not sure I
was doing it right!
Andrew

"Paul D. Simon" wrote:

> First enter the following code into a module of your workbook (or a
> module in your Personal.xls to have available to all workbooks):
>
>
> Sub AssignInsertKey()
> Application.OnKey "{INSERT}", "Paste"
> End Sub
>
>
> Sub Paste()
> ActiveSheet.Paste
> End Sub
>
>
> Now run just the AssignInsertKey macro. (The AssignInsertKey macro
> will automatically initiate the Paste macro.)
>
> Now whenever you do a Copy, all you have to do is hit the Insert Key,
> and whatever you copied will be pasted into whatever cell you're in
> when you hit Insert
>

Paul,
Now this is a bit more at my level! Shift and Insert is a good tip, I can do
it with my right hand while my left hand is using the mouse (being left
handed). I know you can do Control and V with one hand as well but it doesn't
flow easily either with the right hand or keep leaving the mouse and using my
left!

Thanks

Andrew

"Paul D. Simon" wrote:

> Just a couple of additional thoughts...
>
> While I know that you want to use just the single key of Insert to
> Paste, the standard 2-key shortcut of Ctrl+V works very nicely in all
> Windows applications, and 2 keys isn't really such a hardship.
>
> However, if you really like utilizing the Insert key, note that
> without any programming whatsoever, Shift+Insert (while not as
> commonly known as Ctrl+V) is also built into Windows as a 2-key Paste
> shortcut.
>

Glad to have been of help.