Over at DDOE Dick has decreed the first Wednesday of November as International Keyboard Shortcut Day. In a comment to his post I said I’m about 50-50 in my mouse-to-shortcut ratio.
A literal case in point is my use of Alt-F11, which VBA folk will recognize as the key combo that whisks you from Excel to the Visual Basic Editor. I use it all the time. Oddly, I rarely use it in the other direction.
Speaking of the VBE… it still has old-style toolbar menus, the kind you can easily modify. Whenever I get a new computer there’s a few VBE setup things I always do, like install M-Z Tools and Smart Indenter. I also get rid of many of the buttons, like Cut, Copy and Paste. Ctrl-X, Ctrl-C and Ctrl-V were among the first shortcuts I used regularly and it still gives me a sense of competence and tidiness to trash them.
Speaking of the VBE… some of my favorite shortcuts these days are those that combine the Windows key and arrows for moving windows around on your monitor(s). I use them a lot on my laptop, usually to push the VBE to the right and Excel to the left.
Extreme Keyboard Shortcuts
Poking around for pictures to pad this post, one caught my eye with its double meaning:
This one is just whacky. I’ve read the explanation, but I still don’t know what it does. I think the creator may be as fanatical as Dick:
2 key combinations are okay. More than 2, my head begins to hurt, except Ctrl, Shift Enter and Ctrl, Alt, Delete (which I seem to use too often these days π )
I agree two-key combos are nice, although i use Ctrl-Shift-Arrow key combinations all the time to select ranges.
Sounds like you’re living life on the edge π
>Sounds like youβre living life on the edge
Considering the sexy and glamorous lives we Excel programmers have, just the usual stuff π