If your ultimate goal is to become a keyboard only user in Excel, then the Menu Key is very helpful. Thus, you can use the Menu Key to do things in Excel like Paste Special, Insert, Delete, open the Format Cells dialog box and other things you might normally do with the mouse. If you look at a close-up you’ll see that it resembles a mouse pointing at a drop-down menu – as if you had just right clicked. Below is a picture (your keyboard may be different and smaller keyboards may not even include it – but if yours doesn’t you should consider getting one that does - see my Excel Keyboard Review): The Menu Key is typically located on the bottom right side of the keyboard, somewhere between the Alt and Ctrl keys. Hitting the Menu Key (or “Context Menu Key” or “Application Key”) brings up the identical menu. The menu differs, not surprisingly, based on the context. Right-clicking, as you probably already know, brings up an Excel “context menu” that gives you quick access to lots of common commands. This is a short but hopefully useful post. What is the Menu Key and why is it important in Excel? Two others in attendance.Ĭopyrighted work available under Creative Commons Attribution only licence CC BY 4.0 įiled Under: Excel Shortcuts, Paste Special, Save Tagged With: Excel Keyboard Shortcuts, Excel Shortcuts, Hybrid Shortcuts, Paste Special, Quick Access Toolbar - QAT Excel Menu Key Wellcome sitting in a chair with an attendant holding a bowl between his legs to catch blood from the open wound in his stomach. L0003183 Bloodletting, 16th CenturyĬredit: Wellcome Library, London. See, these evil men below are simultaneously bleeding the naked guy in the chair and telling him Excel shortcuts are bad for his health. Bloodletting is as smart as avoiding Excel shortcuts. Multiply this by several hundred million people and you’re hindering the global economy!!! You are in fact decreasing the total amount of cosmic happiness!!! These myths are dangerous indeed! They are nearly as dangerous and misguided as the ancient practice of bloodletting (see below). Therefore, any myths and misconceptions that keep you from learning shortcuts are dangerous to your career. If you decide to put off learning shortcuts, then you are putting off advancing your career. All kinds of new possibilities are opened up for such magnificent people. Being fast at Excel makes you more valuable as employee, which increases your upward mobility on the pay scale. This means: promotions, pay increases and greater job satisfaction. The faster you and your business can run, the more successful you will be. If you are in the business world, you need to know Excel, and the faster you can be at Excel (e.g., with shortcuts), the faster your business (or your part of it) will run.
#KEYBOARD SHORTCUT FOR PASTE SPECIAL SOFTWARE#
Why, you ask? Because Excel is the most popular business software ever in the world (hundreds of millions of users), and probably the most important.
For example, to do Paste Special in this situation, I’ll do a MK-N (menu-key-N).įiled Under: Excel Shortcuts, Paste Special, Paste Values, Right Click Tagged With: Hybrid Shortcuts, Paste Special, Paste Values 4 Excel Shortcut Myths Debunked If my right hand DOES happen to be on the keyboard already, then I’ll do a BB (everything with the keyboard). That would make me an AA in that situation (doing everything with the mouse) in this case. I call this a “ hybrid shortcut” since it uses both the mouse and the keyboard.īut I won’t do a RC-N for Paste Links - I find it faster to just click on the Paste Link icon. For example, I’ll do a RC-V (right-click-V) to Paste Values. I find it faster to click on an option than move my right hand off the mouse, onto the keyboard to type it, and then back to the mouse. Why? I prefer keeping my right hand on the mouse as much as possible. I strive to be an AB (I right click to bring up the menu, then click on the hot key to choose the option).īut that’s only when the hot key is on the left side of the keyboard. (B) With the keyboard (by typing the hot key) (2) How do you select your Excel Paste Special option? (B) With the keyboard (with the menu key)? (1) How do you bring up the Excel Paste Special menu(s)? How do you Paste Special in Excel? Leave a comment!Īre you an AA, AB, BA or BA? See the questions below.
0 kommentar(er)
