Paste Values with the Right-click & Drag Mouse Shortcut

Bottom line: Learn how to use a simple mouse shortcut to quickly copy and paste values in Excel.

Skill level: Beginner

An Unusual Way to Paste Values with the Mouse

In last week's post on 5 Keyboard Shortcuts to Paste Values there were a lot of comments on this method.

I call it the right-click & drag method for pasting values. When we use the right mouse button to move a range, a special menu appears that allows us to paste values.

Here is the shortcut in action.

Here are the steps for the right-click & drag method to paste values:

  1. Select the range you wan to copy.
  2. Move the mouse cursor to the border of the selection until the cursor turns to the cross hairs, like you are going to move the range.
  3. Right-click and hold.
  4. Move the range to a new location.
  5. Release the right mouse button.
  6. A new menu appears. Select the third option: Copy Here as Values Only.
  7. The range is copied and pasted as values only.

This can be slightly faster than right-click > Copy and right-click > Paste Values. There are some pros & cons that I'll discuss below.

Replace Formulas with Values in a Range

Probably the most common use for this shortcut is to replace a range of cells that contains formulas with values.

The process is the same as above, except that you will drag the range back onto itself.

  1. You first have to drag the range up/down/right/left by one cell so that the destination border moves.
  2. Then move the mouse back to it's original location so the original range you selected is highlighted.
  3. Release the right mouse button to choose Copy Here as Values Only from the menu.

I've always done a drag right then left for this technique, but down then up is probably faster. Since the mouse cursor is at the bottom of the range when you select it, you can just right-click and quickly move down then up. Here's a screen cast.

Things to know

There are a few important things to know when using this shortcut.

  • This method can only be used when copying & pasting on the same sheet. You cannot right-click and drag to a different sheet.
  • The range is NOT copied to the clipboard. This can be a pro or con, but I typically consider it to be a positive. You don't have to worry about hitting Escape to exit CutCopy Mode (stop the marching ants around the range) because the range is never copied to the clipboard. This can prevent accidental pastes with the Enter key.
  • After releasing the right-mouse button, you can hit the Escape key if you want to cancel the operation.
  • There are quite a few other handy commands on that right-click menu, and I encourage you to check those out too.

Share it with your co-workers

The quickest way to get your co-workers to buy you lunch is to show them this shortcut. Ok, I'm totally kidding!

However, it's one that not many people know, and it's always exciting to learn a new Excel tip. So feel free to teach your friends or share this post with them.

Please leave a comment below if you have any additional tips or suggestions for pasting values. And don't forget to checkout my last post on 5 Keyboard Shortcuts to Paste Values.

Thanks! 🙂


Your email address will not be published. Required fields are marked *

  • Pretty cool trick. On your latter example, pasting values back over formulas, I feel like [CTRL+C > CTRL+V > CTRL > down arrow twice > enter] is a bit quicker, (at least for me who likes to drive keyboard only as much as possible) and you don’t have to be as careful to finesse your mouse just right. Just my take at least.

  • Great trick! Had no clue about that hidden menu. Played with this menu a bit and found the ‘Shift Down and Move’ option to be a useful way of moving entire rows (instead of Cut and Insert Cut Cells).

  • Hi Dear Jon ,

    First I want to mention that I really enjoy with your videos on Excel.

    Second, about the drag with right click , I am suggesting :
    “Drag by right-click hold” Method.

    Thanks and Best Regards,
    Nabil Kalash

  • This is brilliant! Jon, you are my saviour!

    I’ve lost count of how many times I’ve followed the traditional way of right clicking to copy and paste cells with formulas as values.

    Thank you so much! 🙂

  • Dear Jon, This is fantastic secret and really a time saver for us. I will share my colleagues so that they can benefit too. Many thanks for your contributions towards the excel community.

  • Thanks.. It’s a handy Tip.. but I feel it must be used only in special occasions, this trick can work against you…

  • Hi,
    i need a small help in vba. I have a lookup value which has multiple matches in the lookup range.But that lookup appears only one time in my data sheet.So,my code has to create same lines in my datasheet with each result at a time.

  • Hola, si es posible copiar y pegar en otra hoja del Libro, solo necesitamos primero Alt, seleccionar el rango, arrastrar a la otra hoja y soltar la tecla Alt

Generic filters
Exact matches only

Excel Shortcuts List

keyboard shortcuts list banner

Learn over 270 Excel keyboard & mouse shortcuts for Windows & Mac.

Excel Shortcuts List

Join Our Weekly Newsletter

The Excel Pro Tips Newsletter is packed with tips & techniques to help you master Excel.

Join Our Free Newsletter