Below are what I’ve found to be the fastest Paste Special methods for various tasks. Alernatively you can use Alt > E > S > E. The animation below shows some of the neat things Paste Special can do in Excel: pasting just values (no formatting or formulas), pasting a picture (that you can move around) and pasting formatting onto other numbers.
Using your keyboard to copy an item and then. Simply add Alt for Paste Special and use E for Transpos e. Copying and pasting may bring back memories of crafting in art class, but copying and pasting on a computer or mobile device is a little different. Remember This Shortcut: Ctrl + V is the usual command to Paste. The fastest way to paste a specific aspect of the copied data in Excel is using one of the following shortcuts. If my right hand DOES happen to be on the keyboard already, then I’ll do a BB (everything with the keyboard). This Excel Shortcut pastes and transposes. You can improve excel skills and improve your efficiency. That would make me an AA in that situation (doing everything with the mouse) in this case. In this article we are going to provide 30 MS excel keyboard shortcuts that are very helpful. 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. I demonstrate several techniques to help you to use them to improve your productivity.
#What is the excel keyboard shortcut for paste special how to#
For example, I’ll do a RC-V (right-click-V) to Paste Values. Learn how to take advantage of the new keyboard shortcuts in Excel 2010 for Paste Special Options. 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.