• Skip to main content
  • Skip to primary sidebar

Technipages

Tutorials and fixes for smartphone, gadget, and computer problems

  • Topics
    • Android
    • Browsers
    • Gaming
    • Hardware
    • Internet
    • iPhone
    • Linux
    • macOS
    • Office
    • Reviews
    • Software
    • Windows
    • Definitions
  • Product Reviews
  • Downloads
  • About
Copy and Paste Values Without Formulas in Excel 365

Copy and Paste Values Without Formulas in Excel 365

December 13, 2022 by Mitch Bartlett 15 Comments

When you perform a normal copy and paste on a cell in Microsoft Excel 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.

I hope these steps have helped you successfully copy and paste a value in Excel without the formula. Have questions? Drop one in the comments section.

You Might Also Like

  • Microsoft Excel: How to Enter Basic Formulas
    Microsoft Excel: How to Enter Basic Formulas
  • How to Highlight Duplicate or Unique Values in Excel
    How to Highlight Duplicate or Unique Values in Excel
  • Enable/Disable Display of Formulas in Cells in Excel
    Enable/Disable Display of Formulas in Cells 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

Filed Under: Office Tagged With: Excel, Excel 365, 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

  • How to Make a Drop-Down List in Excel: 2 Best Methods in 2023
  • Can You Mix RAM Brands: A Guide for RAM Mix and Match
  • Google Photos: How to Recover Erased Pictures
  • New Galaxy S23: Full Specs, Features, and More
  • How to Block Calls on Android
  • Mimecast for Outlook: Everything You Need to Know
  • What Is PoE?
  • Excel Calendar Template 2023: The 9 Best Sources You Must Know

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.

© Copyright 2023 Guiding Tech Media · All Rights Reserved · Privacy