Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I was reading in this other post about how to set up a macro to past values in Excel. I understand how to create he macro but I would like to set the keyboard shortcut to Ctrl d but excel pops up an error and says this is taken when I try to utilize that. The other post alludes to the idea that you can over write these or create/edit a macro that will let you still use the Ctrl d with out excel knowing its different.
Any help is appreceiated. I am using excel 2010 on a PC.

share|improve this question
    
Can you upload a screenshot of the error? I just checked with Excel 2010 and was able to assign Ctrl+D as a shortcut to my macro just fine. What does pressing Ctrl+D do for you? Perhaps you've already assigned it to another macro? –  Karan Apr 30 '13 at 18:41
add comment

1 Answer

If you are unable to get a macro assigned, an alternative is to either a) assign a button to your ribbon (I use that all the time), or, b) if it has to be a keyboard solution (I, too, like keyboard shortcuts), SuperUser Doug Glancy answers this with the shortcut that already exists in Excel (along with other great info) in his post:

http://superuser.com/a/212632/221128

"2.Ones like Alt-E-S-V for Edit > Paste Special > Values " (and then press Enter)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.