Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Customize Keyboard
Why is there no button in the Excel Options to customize the keyboard (as
there is in Word Options and as there was for Excel XP and 2K)? I get massive amounts of data from which I delete non-pertinent records. I simplified this by adding a keystroke combo to delete a row. Now I have to type Alt-H-D-R. Two extra keystrokes per instance x 1000 instances per day = NOT FUN. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
Customize Keyboard
You could create macros that do what you want and assign nice keyboard shortcuts
to those macros. Or you could use builtin shortcuts. Shift-spacebar will expand the selection's area with the activecell to the entirerow. then ctrl-hyphen to delete the selection. Or you could add a couple of icons to your favorite toolbar/QAT. In xl2003 tools|Customize|commands tab|Edit category drag Delete Row (or Delete column) to your favorite toolbar. There's a couple of Insert options under the Insert Category, too. TychaBrahe wrote: Why is there no button in the Excel Options to customize the keyboard (as there is in Word Options and as there was for Excel XP and 2K)? I get massive amounts of data from which I delete non-pertinent records. I simplified this by adding a keystroke combo to delete a row. Now I have to type Alt-H-D-R. Two extra keystrokes per instance x 1000 instances per day = NOT FUN. -- Dave Peterson |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
Customize Keyboard
To clarify.
No version of Excel has had the capability nor the option of customizing keyboards. I don't know how you did it in Excel XP and 2K but I would assume through VBA. Gord Dibben MS Excel MVP On Thu, 20 Mar 2008 15:19:00 -0700, TychaBrahe wrote: Why is there no button in the Excel Options to customize the keyboard (as there is in Word Options and as there was for Excel XP and 2K)? I get massive amounts of data from which I delete non-pertinent records. I simplified this by adding a keystroke combo to delete a row. Now I have to type Alt-H-D-R. Two extra keystrokes per instance x 1000 instances per day = NOT FUN. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
customize keyboard shortcuts | Excel Discussion (Misc queries) | |||
customize keyboard shortcuts | Excel Discussion (Misc queries) | |||
in frontpage we should customize keyboard shortcuts | Excel Discussion (Misc queries) | |||
customize keyboard shortcuts | Excel Discussion (Misc queries) | |||
can you customize a keyboard short cut in excel? | Excel Discussion (Misc queries) |