Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Q: Excel - shortkeys
How to define them?
for example I want to define shortkey for Paste Special / Values. thanks for answers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Q: Excel - shortkeys
Saved from a previous post: I don't think you could change the default, but you could add the paste special|Values button to your favorite toolbar. You can get to via Tools|customize|Commands Tab|Edit category Drag the "Paste Values" icon to your favorite toolbar (or create new customized toolbar). Other people have created macros that they assign to shortcut keys (and load with their personal.xl* file so it's always available). Something like: Option Explicit Sub MyPasteSpecialValues() If Application.CutCopyMode = False Then Beep Else ActiveCell.PasteSpecial Paste:=xlPasteValues End If End Sub The assign it a nice shortcut key (Ctrl-Shift-V??). Tools|Macro|Macros Select the macro Click Options type in your shortcut key (case is important) Ok out of that dialog Cancel out of this one. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Lebowski wrote: How to define them? for example I want to define shortkey for Paste Special / Values. thanks for answers -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Q: Excel - shortkeys
Thanks for answer. Its very helpful.
Is it possible to save this pre-defined macro on hard disk and load it to any excel xls document? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel docs not saving as excel docs | Excel Discussion (Misc queries) | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |