• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Gaming
    • Hardware
    • Internet
    • iOS
    • MacOS
    • Office
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About Technipages
Copy and Paste Values Without Formulas in Excel 2019, 2016, & 365

Copy and Paste Values Without Formulas in Excel 2019, 2016, & 365

By Mitch Bartlett 15 Comments

When you perform a normal copy and paste on a cell in Microsoft Excel 2019, 2016, and 365 that has been calculated by a formula, the formula gets pasted as well. There is a simple way around this if you wish to just copy and paste only the value within the cell and nothing more. Just follow these steps.

  1. Select the cells or ranges you wish to copy.
  2. Select the “Home” tab.
  3. Select “Copy” in the “Clipboard section.
    Excel copy cell
  4. Select the cell you wish to paste your values to.
  5. Select the lower half of the large “Paste” button. From the extended menu that appears, select “Values“.
    Excel paste values
  6. Select “OK“.

You have successfully pasted a value in Excel without including the formula.

You Might Also Like

  • Enable/Disable Display of Formulas in Cells in Excel
    Enable/Disable Display of Formulas in Cells in Excel
  • How to Highlight Duplicate or Unique Values in Excel
    How to Highlight Duplicate or Unique Values in Excel
  • Galaxy Tab S3: Cut, Copy and Paste
    Galaxy Tab S3: Cut, Copy and Paste
  • Android: How to Cut, Copy, and Paste Text
    Android: How to Cut, Copy, and Paste Text
  • Galaxy Note8/S8: How to Cut, Copy, and Paste
    Galaxy Note8/S8: How to Cut, Copy, and Paste
  • How to Cut, Copy, & Paste on the Samsung Galaxy S9
    How to Cut, Copy, & Paste on the Samsung Galaxy S9
  • How to Cut, Copy, & Paste on a Samsung Galaxy S10
    How to Cut, Copy, & Paste on a Samsung Galaxy S10
  • How to Copy and Paste in Google Lens
    How to Copy and Paste in Google Lens
  • Microsoft Edge: Can't Copy & Paste URL
    Microsoft Edge: Can't Copy & Paste URL

Filed Under: Office Tagged With: Excel 2016, Excel 2019, Office 365

Reader Interactions

Comments

  1. Muruga says

    January 22, 2022 at 11:13 pm

    Thanks so much for your information. It really helped me a lot. Once the formula generates the values then I copy the value and paste in notepad and then I bring it to excel and reformatting….
    This info is a cool tip for me.

  2. Yurii says

    June 14, 2020 at 7:22 am

    I use Ctrl + Shift + C to copy and Ctrl + V to paste without formatting

  3. Sebastian says

    March 19, 2020 at 10:00 am

    Dear Mitch,

    thank you for helpful summary. It really helped. While thinking about it, there is another workaround.

    You could take the value you need to copy and paste to a cell outside the columns you need to enter data.

    (Example:
    The formula which generates the wanted value is in A1.
    You could copy the formula or use =VALUE(A1) in B1.
    Then go to Review->Protect. Open Allow Edit Ranges.
    Set it to allow entries in the columns/rows you need to enter data (in this example column A).
    Then right click on B1, go to format cell->Protection. Check locked and hidden. Then protect the sheet. After you have done that, if you click on B1 and right click copy it will only copy the actual value in B1. The formula won’t be copied.
    If you set the allow range properly, you still can change/enter stuff in column A.

    Sincerly yours Sebastian

  4. ayad says

    January 20, 2020 at 1:10 am

    can it be done automatically with a function? when i change the value in the function i want to not Change the copy .

  5. Priyanka says

    January 3, 2020 at 3:38 am

    Good Method to paste

  6. George says

    July 24, 2019 at 2:35 am

    can it be done automatically with a function?

  7. Kostadin says

    June 14, 2019 at 8:53 am

    Thank you Mitch Bartlett for this very useful information. :-)

  8. Abdelrahman Elshorafa says

    May 3, 2019 at 1:15 pm

    Thanks so much for useful description

  9. Mike says

    April 4, 2019 at 8:41 am

    so, to summarize – you have no info, how to copy values without formulas, you know only how to paste them. So – could you fix the name of this page, as its totally incorrect for this moment?

  10. Chaman Lal Dewangan says

    March 28, 2019 at 2:47 am

    It is very helpful. Thank You

  11. Kaustav Khatua says

    March 3, 2019 at 6:42 am

    It was very much helpful. Thank you.

  12. Benjamin says

    February 26, 2019 at 9:00 am

    Thanks i tried but i failed

  13. Hitesh says

    January 19, 2019 at 3:34 am

    Is there a keyboard shortcut for this?

  14. Efrem1 says

    December 22, 2018 at 8:51 am

    Thank you !

  15. nicole says

    October 21, 2018 at 11:06 pm

    thank you very much Mitch Bartlett for what you are doing. It is a tremendous help !

Did this help? Let us know!

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Recent Posts

  • Windows 11: How to Add Clocks with Different Time Zones
  • Google Assistant: How to Never Miss a Birthday
  • Windows 11: How to Disable Notifications and Ads
  • How to Use Oculus Quest 2 Air Link
  • How to Create an Avatar in the Oculus Quest 2
  • 5 Free and Fun Math Apps for Kids
  • Windows 11: How to Discover What Graphics Card You’re Using
  • How to Change Display Resolution on Windows 10 and 11

Who’s Behind Technipages?

Baby and Daddy My name is Mitch Bartlett. I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all.

You May Also Like

  • 8 Best Laser Printers (Review) In 2019
  • Top 7 Affordable Gaming Laptops in 2019
  • 10 Best Android Phone Cleaner Apps in 2019

© Copyright 2022 Technipages · All Rights Reserved · Privacy