Paste Buddy Add-in Help Page | Excel Campus

Paste Buddy Help

Paste Buddy Help Page Logo

Paste Buddy is very easy to setup and use.  This page provides instructions to get you started.  Please leave a comment or contact me with any questions.

Click here if you are looking for the Paste Buddy Download Page.

Installation

Please see my Guide on Installing an Excel Add-in for detailed instructions on installing the Paste Buddy Add-in.

After you have installed and used Paste Buddy, an additional settings file will be added to the same folder that you save the add-in file in (“Paste_Buddy_Settings.ini”).  This file just stores your keyboard shortcut settings so you can use Paste Buddy when multiple instances of Excel are open.  Please do not delete this file.

Video Tutorial

Setup the Keyboard Shortcuts

Once installed, the Paste Buddy button will appear on the Add-Ins tab of the Excel Ribbon.  This button will appear every time you open Excel.

Click the Paste Buddy button to open the Paste Buddy Setup Window.

 Paste Buddy Open Setup Window - Excel

In this setup window you can create the keyboard shortcuts that will perform the paste special commands.

The setup window contains a list of 12 keyboard shortcuts where you can customize the following:

  • Key – This is the keyboard shortcut combination that will perform the paste special command when pressed.  All shortcuts begin with Ctrl+Shift.The full keyboard shortcut is Ctrl+Shift+Key.  The Key is the third key that is required in the keyboard shortcut.  In the example above, the keyboard shortcut for paste values is setup as Ctrl+Shift+V.
  • Paste Option – This is the Paste Special command that will be performed when the keyboard shortcut is pressed.  There are a list of 11 different paste special options in the Paste Option drop-down boxes.
  • Operation – This is the additional operation that can be performed with the paste option.  These operations include: Add, Subtract, Multiple, Divide, Transpose, & Skip Blanks.

Setup Example:

Let’s walk through an example of how to setup a keyboard shortcut to Paste Values:

Click the Paste Buddy button in the Add-Ins tab of the Ribbon.  The Setup Window will open.

  1. Type the letter V (or any key you want) in the Key text box in row 1.Paste Buddy Setup Step 1 - Key_
  2. Select Values from the Paste Option drop-down box in row 1.
    The Operation drop-down can be left as None for this example.Paste Buddy Setup Step 2 - Paste Option_
  3. Click the Save & Close button.Paste Buddy Setup Step 3 - Save Close_

That’s it!  The shortcut to Paste Values is now setup as Ctrl+Shift+V

Now put it to the test:

  1. Select a cell in your worksheet that contains a formula and/or formatting and press Ctrl+C to copy it.Paste Buddy Paste with Shortcut Key Step 1 - Copy_
  2. Select a blank cell and press Ctrl+Shift+V to paste the values of the copied cell.  The formula and formatting will NOT be copied.  Only the value of the copied cell will be pasted in the selected cell.Paste Buddy Paste with Shortcut Key Step 2 - Paste Values

You Can Undo

The Paste Buddy shortcut key works just like any other paste special command in Excel.  You can press Ctrl+Z or the Undo button to undo your action.

Full Undo History Menu Example

 The Key List

You can create up to 12 different keyboard shortcuts in the Paste Buddy setup window.

How are you going to remember all these?  Pressing the “Key List” button on the setup window will create a new Excel workbook with a list of all your shortcut keys.

Paste Buddy Key List

This list is formatted for printing so you can print it out and put it on your desk.  You can use this a reference to help you remember your shortcut keys.  It is especially useful for the commands that you don’t use that often.

Have More Questions?

Please leave a comment below or contact me with any questions or product suggestions you have.  I want you to love Paste Buddy, and together we can make it better. 🙂

Click Here to Leave a Comment Below 18 comments
Barbara - January 16, 2017

Finally have time to write this question…My Paste Buddy – full developer version using on Excel 2010 – When I first installed per the directions, it worked splendidly. However, the next time I started Excel, the EC tab has disappeared, taking my Paste Buddy with it. File options say it is an active add in, but it doesn’t appear in my Add In drop down. Suggestions? I loved it and want it back.

Reply
    Jon Acampora - January 16, 2017

    Hi Barbara,
    I’m sorry to hear you are having that issue. It’s due an a Office security update that was released a few months ago. That update causes the add-in’s tab to disappear without warning. Fortunately, there is a pretty quick fix for it. The following article explains how to fix it. You will likely have to do the last step to Unblock the add-in file.

    https://www.excelcampus.com/vba/add-in-ribbon-disappears/

    Please let me know if you have any questions. Thanks again!

    Reply
      Barbara - January 17, 2017

      Thanks, Jon. Making the file location trusted didn’t help, and I couldn’t find block/unblock in file properties. However, when I disabled and re-enabled per another commenter’s suggestion, my tab magically reappeared. I really appreciate your quick responses.

      Reply
Barbara - December 1, 2016

Instead of a problem, I’m leaving kudos! I do so much copying and pasting, and Paste Buddy is saving me a ton of keystrokes. My own personal second-by-second LEAN project.

Reply
    Jon Acampora - December 1, 2016

    Hi Barbara, Thank you so much! I really appreciate you taking the time to let me know, and happy to hear Paste Buddy is helping you. Have a great day! 🙂

    Reply
Clement - April 15, 2016

Hello, just tried to install excelbuddy & did but installation came with error
I’m running 2016

1. How to uninstall it properly?
2. Do you have compatible version of your tools?

Regards

Reply
    Jon Acampora - April 15, 2016

    Hi Clement,
    The trial version is compatible with the 32-bit Windows version of Excel 2016. It is not compatible with 64-bit. Are you running 64-bit? The full version is compatible with 64-bit. Let me know and I can help you out.

    Paste Buddy is not compatible with Mac versions of Excel. Thanks!

    Reply
Dan Bridges - December 6, 2015

I show the trial program as an active program in excel. However, when I try to use it, nothing will happen. The window doesn’t open when I click the icon to select the cells to copy and paste.
Not sure why.
Thanks,

Reply
    Jon Acampora - December 7, 2015

    Hi Dan,

    Sorry to hear you are experiencing issues with the add-in. What version of Excel are you using?

    Thanks,
    Jon

    Reply
    Daniel Bridges - December 7, 2015

    I am using 2007 version.

    Reply
      Jeff - December 30, 2015

      I’m facing it too.. im running paste full version buddy on excel 2007,
      when I try to paste, e.g, CTRL+Shift+V, nothing happens, and I get a dialogue box up in the tool bar that says: “Office access key: Alt, E. Continue typing the menu sequence from an earlier version of Office or press ESC to cancel.
      any solution?

      PS: The paste visible function work flawless tho..

      Reply
        Jon Acampora - January 6, 2016

        Hi Jeff,
        Sorry to not get back to you sooner. Paste Buddy uses a sendkeys workaround to make the magic happen. That basically means that it presses the native Excel keyboard shortcut for you. If you don’t release all the keys at the same time it can get stuck in the middle of process. Try messing around with how you release the shortcut Ctrl+Shift+V. You might be able to get it to work by pressing and releasing the keys all at the same time. I hope that helps. Thanks!

        Reply
      Dan Bridges - September 13, 2016

      Jon,
      I left you an email message yesterday. I am stuck. It just won’t open to do anything from the tab where it resides in the toolbar. I re-downloaded it. I rebooted. I restarted excel. Checked the disabled area. All checks out. Hope there is something that can be done. I like what it does when it works.
      Thanks,
      Dan

      Reply
Courtney - November 11, 2015

i keep getting an error trying to use the trial in excel 2013
compiled error in hidden module… its says VB error

Reply
Tom Doyle - August 21, 2015

Installed the Paste Buddy plug-in and it is active in Excel 2010 plug-in list. The tab is above the tool bar. I opened the tab and am using the default values.
But when I try to paste, e.g, CTRL+Shift+V, nothing happens, and I get a dialogue box up in the tool bar that says: “Office access key: Alt, E. Continue typing the menu sequence from an earlier version of Office or press ESC to cancel.

How do I fix this and get Paste-Buddy to work properly?

Thanks,

Tom D.

Reply
    Jon Acampora - August 22, 2015

    Hi Tom,
    Sometimes you have to release all the keys at the same time. Otherwise the macro doesn’t fire completely. This is definitely a workaround solution but usually works really well. Try to release the all three keys at the same time and see if it works for you.
    Thanks!

    Reply
lou kersten - June 18, 2014

hi,
when i try to save i get this error:

Run-time error 75. Path/File Access Error copying files
I use excel 2013 Dutch

Reply
    Jon Acampora - June 18, 2014

    Hi Lou,

    Sorry to hear that. Let’s see if we can get it fixed.

    Where did you save the add-in file? What folder did you save it in?

    When you click the Save & Close button in the Paste Buddy Window, a new settings file is created and saved in the same folder as the add-in file.

    It sounds like the error is occurring when the settings file is being saved.

    Do you see a file named “Paste_Buddy_Settings.ini” in the same location as the add-in file?

    Thanks,
    Jon

    Reply

Leave a Reply: