Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to assign Ctrl+Shift+Insert to Paste Values?
It used to be possible to do it, but suddenly it seems that Excel
assign user-defined shortcuts only as Alt+letter and nothing more complicated than that. Is there way how to get around? Thanks, Matej |
#2
|
|||
|
|||
Hi Matej
You can use Ctrl-C to Copy, Ctrl-X to Cut, Ctrl-V to Paste Regards Roger Govier wrote: It used to be possible to do it, but suddenly it seems that Excel assign user-defined shortcuts only as Alt+letter and nothing more complicated than that. Is there way how to get around? Thanks, Matej |
#3
|
|||
|
|||
Hi Matej,
Yes, I think the dialog was slightly changed. If you hit the SHIFT key when assigning your shortcut you will see +SHIFT being added to your shortcut assignment. But the Ins (insert key) is not available as a shortcut key, which appears to be meant as part of the question hidden on your subject line where it will be ignored when actually reading a question. http://www.mvps.org/dmcritchie/excel/shortx2k.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Roger Govier" wrote in message ... Hi Matej You can use Ctrl-C to Copy, Ctrl-X to Cut, Ctrl-V to Paste Regards Roger Govier wrote: It used to be possible to do it, but suddenly it seems that Excel assign user-defined shortcuts only as Alt+letter and nothing more complicated than that. Is there way how to get around? Thanks, Matej |
#4
|
|||
|
|||
Of course, that I know that (I am much behind this level), but I need
to assign to key shortcut to Paste values only (so that pasting want destroy formatting of target cells). ANy thoughts? Matej |
#5
|
|||
|
|||
Another case of part of the question is in the subject title.
Please include the entire question in the body. You want the equivalent of Edit, Paste Special, Values after copying your entire worksheet (Edit, Move or copy, be sure to check copy worksheet) So a common shortcut would be Ctrl+Shift+V to paste values using your own macro. http://www.mvps.org/dmcritchie/excel/paste.htm#values No matter what your choose Ctrl+Shift+V or Ctrl+Shift+P you are very likely to override a builtin Excel shortcut, so you might want to check that to see if you really want that shortcut. http://www.mvps.org/dmcritchie/excel/shortx2k.htm Also note with Edit, Paste Special what your options are. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm wrote in message ups.com... Of course, that I know that (I am much behind this level), but I need to assign to key shortcut to Paste values only (so that pasting want destroy formatting of target cells). ANy thoughts? Matej |
#6
|
|||
|
|||
Thanks a lot!
Matej |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste special values | Excel Worksheet Functions | |||
excel - numbers as text | New Users to Excel | |||
Challenging Charting | Charts and Charting in Excel | |||
Paste values ID | Excel Discussion (Misc queries) | |||
how to paste the values in reverse order in workbook | Excel Discussion (Misc queries) |