Paste Buddy A Fast New Way to Paste Values in Excel 3. How Do You Paste Values What method do you use to paste values in Excel Im talking about copying a cell that contains a formula or number formatting, and pasting the values of that cell to another cell. Excel Shortcuts Keys List 2010 Pdf' title='Excel Shortcuts Keys List 2010 Pdf' />A reader writes From reading the comments on AAM, it seems many of your readers are Excel gurus. I use Excel a lot at work but feel like Im only scratchi. Learn excel keyboard shortcuts for Selection, Editing, Formatting, Formulas, Navigation and pretty much everything else. Keyboard shortcuts will help you derive. Excel Formulas, Data, Tables, VBA Ways to use Excel formulas and data, including worksheet functions, range names, cell references, databases, lookup methods. Free Resources. Below are some resources that we offer for free. Our live and online courses make liberal use of shortcuts from the WST Macros Excel AddIn, so. Why use keyboard shortcuts in Excel The good thing about memorising this keyboard shortcut is that you dont need to hunt for each menu item, as these might look. There Are A LOT of Ways to Paste Values. Did you know that there are at least eight different ways to perform the paste special commands in Excel  Eight different ways That means that we spend a lot of time copying and pasting. Since its something we do so often, its best to figure out which of these eight methods is the fastest. Which Method is the Fastest If you are a reader of my blog, you probably know that I am constantly trying to find the fastest and most efficient ways to get things done in Excel. One of the fastest ways I have found to paste values is to add the paste special buttons to the Quick Access Toolbar QAT and then use the built in Alt keyboard shortcuts. Most Ways to Paste Values are Slow or Difficult. Most of the other built in methods require multiple mouse clicks or key presses. This makes them slow andor difficult to perform. Using the QAT is great, but many people find that to be quite a stretch with the fingers. It also prevents you from using the QAT for other commands that do not have keyboard shortcuts. So I have developed a solution that has saved me a lot of time and will hopefully do the same for you. Paste Buddy will Save You Tons of Time. Paste Buddy is an Excel Add in that allows you to create custom keyboard shortcuts for any of the paste special commands like paste values, formulas, formats, and more. This means you can choose keyboard shortcuts for any of your favorite paste special commands. And the keyboard shortcuts are fast and easy to perform in one step. In the following example I am using the keyboard shortcut CtrlShiftV to paste values in the the worksheet. In the above video I use CtrlC to copy cell C8. Then I use the keyboard shortcut CtrlShiftV to paste the values in cells E6 E8. I then undo my actions with CtrlZ to show that you can still use Undo with Paste Buddy. Its a really fast way to paste values, and you can setup custom shortcuts for any of the paste special commands. How Does Paste Buddy Work Paste Buddy is an Excel Add in that will automatically load every time you open Excel. It remembers your shortcuts and only needs to be setup once. Once the add in is installed, the Paste Buddy button will appear on the Add Ins tab of the ribbon. Clicking this button will open the Paste Buddy setup window. The following is a screenshot of the Paste Buddy setup window where you can create keyboard shortcuts for any of the paste special commands. This window is only used for setting up the shortcut keys. The setup window is NOT open when you are working in Excel and copying pasting in a worksheet. Paste Buddy works in the background and you wont even know hes there. The following image shows an example of how Paste Buddy works The built in keyboard shortcut in Excel to paste values is AltESVEnter. Paste Buddy basically presses these keys for you when you press CtrlShiftV. So all you have to do is press CtrlShiftV on the keyboard, and Paste Buddy will press AltESVEnter for you. This makes it very fast and easy to perform any of the paste special commands. Paste Buddy really is your buddy, and his job is to help make your life easier. Can I Undo YES  Lets say you accidentally press one of your Paste Buddy shortcut keys and need to undo it. Not a problem.  The full undo history is retained in Excel, so you can always press the Undo button CtrlZ if you make a mistake. New Feature Paste to the Visible Cells Only. If you have ever received the following error message in Excel, The command cannot be used on multiple selections, then you know that you cannot paste to the visible cells in range that contains hidden rows or columns. This is a limitation of Excel, and it can be frustrating. The video below explains two workarounds for this, including a new Paste Visible feature. Paste Buddy has a new feature that allows you to do this with the click of a few buttons. This feature allows you to quickly paste to the visible cells in a range that contains hidden rows or columns. It also allows you to choose from any of the paste special commands like paste values, paste formulas, and paste formatting when performing the paste. What do Paste Buddys Friends ThinkThanks for putting these tools together, they are a huge timesaver  I have people ask me all the time How did you do that so quickly, and besides being an Excel Guru, I usually tell them about the great addins that I have found. Peter R., Logistics EngineerThe Paste Buddy add in is very practical and can customize my paste actions easily. Mental Ray 3Ds Max 2013. It works very well in my Excel 2. BR.   Felipe, Microsoft Excel MVPI like this version because it has the undo feature still available. I liked how you can program it to do all of the paste special commands. Don H., Vice President, FP APaste Buddy is one of those tools you wonder how you managed without. I like how you can customise it to suit your needs and preferences, and it has certainly improved my efficiency. Thanks for filling this gap in Excel functionality. Mynda T., Microsoft Excel MVPPaste Buddy Will Save You Time Paste Buddy is one of those friends that you can depend on to make your life easier. His main goal is to save you time. He can help you in a lot of ways Quickly perform any of the paste special commands with a custom keyboard shortcut. You decide what keys you want to use, making the shortcuts easy to learn and remember. Make it comfortable for your hands to press the shortcuts. If CtrlShiftV is too much of a stretch for your fingers, then you can use keys that are closer to the left side like Z, X, C, A, etc. If you are left handed, then you can use keys closer to the right side like, lt, etc. Keeps your hands in the action by using the CtrlShiftletter combination. The fastest way to copy paste in Excel is by using the keyboard shortcuts CtrlC and CtrlV. Paste Buddys CtrlShiftletter shortcuts are a natural extension of this. Once you press CtrlC to copy, your fingers will already be in right place to perform the paste or paste special command. This makes it very, very fast to paste. Change your shortcut keys for different tasks at any time. Lets say youre working on a task that requires you to perform a paste special command like transpose over and over again. You can quickly change one of your favorite Paste Buddy key combinations to perform the transpose. Then change it back when you are done with the task. Become a keyboard ninja in Excel. If you dont know a lot of keyboard shortcuts yet, dont worry. The best way to learn is to start with the basics. As you start using the Paste Buddy shortcuts to paste values, you will want to learn more keyboard to keep your hands on the keys. Over time you will become much more productive and save lots of time with your every day tasks. Easily remember you shortcut keys with the printable Key List. Once you setup all your shortcut keys, Paste Buddy will give you a list of them to print out for reference. This makes it easy to learn and remember them. I have my list taped to the side of my monitor. Undo your actions with Excels Undo button CtrlZ. Paste Buddy is there when you need him, but doesnt get mad if you accidentally call him.