How to customize Paste Value Excel Short Cut
up vote
0
down vote
favorite
I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code.
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 overwrite these or create/edit VAB code that will let you use Ctrl d without Excel knowing it is different.
I am using Excel 2010 on a PC.
microsoft-excel keyboard-shortcuts microsoft-excel-2010 vba copy-paste
edited Mar 20 '17 at 10:17
Community♦
1
asked Apr 30 '13 at 14:09
user221038
111
add a comment |
up vote
0
down vote
favorite
I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code.
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 overwrite these or create/edit VAB code that will let you use Ctrl d without Excel knowing it is different.
I am using Excel 2010 on a PC.
microsoft-excel keyboard-shortcuts microsoft-excel-2010 vba copy-paste
edited Mar 20 '17 at 10:17
Community♦
1
asked Apr 30 '13 at 14:09
user221038
111
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
Ctrl + D is used by Excel. it copies the cell above.
– PeterH
Nov 26 at 14:05
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code.
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 overwrite these or create/edit VAB code that will let you use Ctrl d without Excel knowing it is different.
I am using Excel 2010 on a PC.
microsoft-excel keyboard-shortcuts microsoft-excel-2010 vba copy-paste
edited Mar 20 '17 at 10:17
Community♦
1
asked Apr 30 '13 at 14:09
user221038
111
I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code.
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 overwrite these or create/edit VAB code that will let you use Ctrl d without Excel knowing it is different.
I am using Excel 2010 on a PC.
microsoft-excel keyboard-shortcuts microsoft-excel-2010 vba copy-paste
microsoft-excel keyboard-shortcuts microsoft-excel-2010 vba copy-paste
edited Mar 20 '17 at 10:17
Community♦
1
asked Apr 30 '13 at 14:09
user221038
111
edited Mar 20 '17 at 10:17
Community♦
1
asked Apr 30 '13 at 14:09
user221038
111
edited Mar 20 '17 at 10:17
Community♦
1
edited Mar 20 '17 at 10:17
Community♦
1
edited Mar 20 '17 at 10:17
Community♦
1
1
asked Apr 30 '13 at 14:09
user221038
111
asked Apr 30 '13 at 14:09
user221038
111
asked Apr 30 '13 at 14:09
user221038
111
111
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
Ctrl + D is used by Excel. it copies the cell above.
– PeterH
Nov 26 at 14:05
add a comment |
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
Ctrl + D is used by Excel. it copies the cell above.
– PeterH
Nov 26 at 14:05
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
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
Ctrl + D is used by Excel. it copies the cell above.
– PeterH
Nov 26 at 14:05
Ctrl + D is used by Excel. it copies the cell above.
– PeterH
Nov 26 at 14:05
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
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:
https://superuser.com/a/212632/221128
"2.Ones like Alt-E-S-V for Edit > Paste Special > Values " (and then press Enter)
edited Mar 20 '17 at 10:16
Community♦
1
answered May 1 '13 at 0:28
ppfooie
49116
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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:
https://superuser.com/a/212632/221128
"2.Ones like Alt-E-S-V for Edit > Paste Special > Values " (and then press Enter)
edited Mar 20 '17 at 10:16
Community♦
1
answered May 1 '13 at 0:28
ppfooie
49116
add a comment |
up vote
0
down vote
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:
https://superuser.com/a/212632/221128
"2.Ones like Alt-E-S-V for Edit > Paste Special > Values " (and then press Enter)
edited Mar 20 '17 at 10:16
Community♦
1
answered May 1 '13 at 0:28
ppfooie
49116
add a comment |
up vote
0
down vote
up vote
0
down vote
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:
https://superuser.com/a/212632/221128
"2.Ones like Alt-E-S-V for Edit > Paste Special > Values " (and then press Enter)
edited Mar 20 '17 at 10:16
Community♦
1
answered May 1 '13 at 0:28
ppfooie
49116
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:
https://superuser.com/a/212632/221128
"2.Ones like Alt-E-S-V for Edit > Paste Special > Values " (and then press Enter)
edited Mar 20 '17 at 10:16
Community♦
1
answered May 1 '13 at 0:28
ppfooie
49116
edited Mar 20 '17 at 10:16
Community♦
1
edited Mar 20 '17 at 10:16
Community♦
1
edited Mar 20 '17 at 10:16
Community♦
1
1
answered May 1 '13 at 0:28
ppfooie
49116
answered May 1 '13 at 0:28
ppfooie
49116
answered May 1 '13 at 0:28
ppfooie
49116
49116
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f589672%2fhow-to-customize-paste-value-excel-short-cut%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
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
Ctrl + D is used by Excel. it copies the cell above.
– PeterH
Nov 26 at 14:05