excel shortcut keys paste special values

Say that you have to copy and paste as values.

There was a whole section of the card dedicated to the keyboard shortcuts for the various forms of Paste Special.

Now - I sell a bunch of laminated tip cards, but none of them are as hard-core as the AMT card. I've heard some big firms make new hires total an entire page from a phone book on a 10-key adding machine until they can key numbers with 100% accuracy without ever looking at the keys.Īnyway, AMT offered a laminated tip card for Excel. These Wall Street firms (and their counterparts in London and Hong Kong) are serious about Excel and never using the mouse. This is a firm who trains Wall Street in Excel. I talked to a lot of people including German Nande from AMT Training. People from all over the world flew to New York to compete head-to-head in Excel. Today, I want to introduce you to Alt + E S which is the gateway to the wonderful world of Paste Special options.Ī few years ago, I was a judge for the ModelOff World Excel Championships. Click More help for your Mac (bottom left corner of Help window).It is mouse-free Monday.Click the help menu and choose (numbers) help.Mac Help can be reached via the Help menu in Finder, or in two three steps from the Help menu in any Apple application (such as Numbers). The second linked page is specific to MS Excel for Mac 2011 in it's demonstration of the problem, where the choice of 'Values' is made in a dialogue box rather than in a submenu (adding two clicks to the mouse and menu process compared to the same procedure in Numbers).Īlthough what is shown on the page is similar to the 'standard' procedure for creating these shortcuts for use on other applications on the Mac, the user may find the instructions in Mac Help more suitable for use in applications other than Excel. In Numbers, Paste Values is in the top level of the Edit menu.įew items on submenus have keystroke shortcuts in OS X applications, and none of these I've found are shortcuts requiring two steps. In Excel, Paste Values is in the Paste Special submenu of the Edit menu. According to the first linked page, this two-step shortcut is applicable to Microsoft Excel, not to Numbers.

Excel shortcut keys paste special values