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.
- Select the cells or ranges you wish to copy.
- Select the “Home” tab.
- Select “Copy” in the “Clipboard section.
- Select the cell you wish to paste your values to.
- Select the lower half of the large “Paste” button. From the extended menu that appears, select “Values“.
- Select “OK“.
You have successfully pasted a value in Excel without including the formula.
You Might Also Like
Excel 2019 & 2016: Force "Open as Read Only" Prompt- Enable/Disable Display of Formulas in Cells in Excel
Galaxy Tab S3: Cut, Copy and Paste- How to Cut, Copy, & Paste on a Samsung Galaxy S10
- Android: How to Cut, Copy, and Paste Text
- Galaxy Note8/S8: How to Cut, Copy, and Paste
- How to Cut, Copy, & Paste on the Samsung Galaxy S9
- How to Highlight Duplicate or Unique Values in Excel
George says
can it be done automatically with a function?
Kostadin says
Thank you Mitch Bartlett for this very useful information. :-)
Abdelrahman Elshorafa says
Thanks so much for useful description
Mike says
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?
Chaman Lal Dewangan says
It is very helpful. Thank You
Kaustav Khatua says
It was very much helpful. Thank you.
Benjamin says
Thanks i tried but i failed
Hitesh says
Is there a keyboard shortcut for this?
Efrem1 says
Thank you !
nicole says
thank you very much Mitch Bartlett for what you are doing. It is a tremendous help !