Six Ways To Paste Values In Excel

Excel provides many ways to paste values from a formula to another cell. Here are 6 ways you can do that.

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!

3 Responses to Six Ways To Paste Values In Excel

  1. Jack Madden February 3, 2015 at 9:14 am #

    Hi Mike:
    When I try your last example I do not get the menu that is shown for choosing which way to save? I am using Excel 2013 as I think you are. I looked in the options to see if that menu was an option could not see anything that helped??

    • Michael Rempel February 3, 2015 at 10:43 am #

      Not sure what to tell you. I use this method almost daily, it’s my preferred method to paste values. You need to hover over the edge of the cell or range of cells you want to paste as values. Then, right-click (not left click), hold and drag the range off then back on to the same spot. That menu should appear. Please try again and let me know what happens.

      • Jack Madden February 3, 2015 at 11:05 am #

        Hi Mike:
        Thanks for the quick reply. Right click not left click, my mistake.
        Again Thanks

Leave a Reply