So, for example, to paste Values and Multiply them against the selection you’re pasting into, the full sequence would be Alt-H-V-S-V-M. (The default selections are Paste All and Operation None, which you’ll get if you don’t enter anything before hitting Enter). Just type the letter for the commands you want (one for the top section, one for the middle section, and one or two (or none) for the bottom section), then hit Enter.
Once this dialog box is up, you’ll see that each menu option has an underlined letter – e.g., ‘V’ for Values and ‘M’ for Multiply. Thus, to bring up the Paste Special dialog box, the entire Alt shortcut sequence would be Alt-H-V-S: The three dots (…) mean that selecting the option will bring up a dialog box. The bottom Paste option - an ‘S’ for ‘Paste Special…’ - has those three dots at the end. (Note: You can tell that you’ll go down another level after hitting ‘V’ because there’s a little down arrow beneath the word ‘Paste’, just above the letter V - that tells you there’s another menu. The same would happen for any option that has that little down arrow.).īut because Paste Special has so many applications, there’s yet another level you can access. So if I choose ‘U’ to paste as a Picture, the full Alt shortcut sequence would be Alt-H-V-U. In other words, you need one more key in your keystroke sequence.Ībove, you can see the various access keys for the Paste Options – ‘P’ for regular Paste, ‘F’ for Formula and ‘U’ for Picture, to name a few. This happens because there are multiple Paste options, and you have to tell Excel which one you want.
If you type ‘V’ (for Paste), you’ll go down another level into the Ribbon, and see yet another set of access keys. This occurs when the Ribbon has another level to it - for example, for the Paste icon.
Sometimes you’ll type a letter and end up with yet another set of access keys to choose from. Alt-H-F-P is the shortcut for Format Painter. If you see two letters next to each other instead of just one – e.g., ‘FP’ for Format Painter in the Home tab image above – just type both letters in sequence (they don’t have to be pressed simultaneously)). To continue with some examples, If you type ‘1’ (or Alt-H-1) you’ll format with Bold (same as Ctrl+B or Ctrl+2) since the 1 is the access key for Bold. You don’t need to press any keys simultaneously. You type Alt, let go, then type H, let go, and then type X and let go. So, for example, if after hitting Alt-H, you then type ‘X’, you’ll Cut (the same as Ctrl+X), since the X is the access key for Cut. After that, you’ll type a letter (or letters) to execute your command.
EQUIVALENT OF F KEYS FOR EXCEL MAC PLUS
And now the Home tab will display access keys for its Ribbon options (I am truncating the Ribbon in the interests of space):Įvery keyboard accelerator requires the first two keystrokes - Alt plus an access key. Here’s An Example: Alt-H-V-U To Paste A PictureĪfter hitting the Alt key, if you then hit ‘H’ (for example), those initial access keys (one for each tab) will disappear and you will be magically transported to the Home tab (because ‘H’ is the Home tab’s access key). It doesn’t matter what tab you’re on when you hit Alt in Excel – you’ll see the same things light up: a letter for each tab, and a number (or number/letter combination) for each QAT option. In this post I’ll stick with “access keys.” Terminology-wise, the letters and numbers that pop-up are alternately called “badges” or “key tips” or “key tip badges” or “access keys” or “hot keys” or “hotkeys.” The shortcuts that you can string together with them - the keystroke sequences - are called “keyboard accelerators.” Not everyone uses the terminology the same, so it can be confusing when you read about this subjec t. These letters and numbers guide you through keystroke sequences that allow you do do virtually anything with your keyboard - instead of clicking with your mouse - as I’ll explain below. If you hit the Alt key you’ll see the Ribbon and the QAT ( Quick Access Toolbar – just below the Ribbon) light up with letters or numbers. If you’ve ever seen someone use both hands all day long on the keyboard in Excel, chances are they were using Alt shortcuts or “keyboard accelerators.” So what are they and how do they work?
0 kommentar(er)
