How do I set my "Insert" key as a paste command shortcut in Excel

A

Andrew Ball

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!
 
A

Andrew Ball

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
 
P

Paul D. Simon

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
 
P

Paul D. Simon

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.
 
A

Andrew Ball

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
 
A

Andrew Ball

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top