msgbartop
Excel spreadsheet and Access database development and VBA programming for Excel Power Users & Programmers
msgbarbottom

13 Jul 09 Acceleration with the keyboard

The air is boiling at my place.

Not only the computers, and the spring/summer are heating me, but I’ve completely turned on a key on my keyboard.

I’ve already had something similar with software, computers, mouse devices, but this is something else! :-D

You will understand it soon, because it’s a logical love. Maybe my bride will understand it too…

It was between the right ALT and the right side CTRL and it haven’t really bothered me for a long time, what is it for, or what does it depict. It was there with its abilities to be discovered.

Luckily I pressed it, and a miracle happened! The local menu appeared!

It’s incorporated in most of the programs, and it contains the actions that can be performed in the current situation.

It can accelerate your work a lot, because you don’t need to use the mouse.

localmenu hotkeys shortcuts

Let’s take a look at its usage. I demonstrate it in Excel, but it works identically in most of the software.

When I press this button the local menu appears.

We can step through the menu items with the up-down arrows, and can execute one with Enter.

It is even quicker to find the underlined letter in the menu item to be selected, and when the local menu is visible, just press that letter in the keyboard, and the action will be executed right away. (In the picture the letter “F” is underlined in “Format Cells…”)

The local menu can be turned off with the ESC button.

If you liked or disliked this article, I wait your comments.
If lots of people liked this one, I will publish some other keyboard shortcut tricks too. And of course other tricks too.

Leave a Comment