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

  • Thread starter Thread starter Andrew Ball
  • Start date Start date
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!
 
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
 
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,
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

Similar Threads

New shortcuts in Excel 2007 1
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9
Can I assign keyboard shortcuts for special characters in Excel 20 1
Pasting objects in Excel 1
Is there a keyboard shortcut to switch between Excel sheets? 1
Are there shortcut keys in Excel for Cell Alignment? 6
What is the keyboard shortcut to insert a bullet in Excel 2003? 1
Type a symbol useing shortcut keys rather the insert a symbol 2

Back
Top