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.
Kostadin says
June 14, 2019 at 8:53 amThank you Mitch Bartlett for this very useful information. :-)
Abdelrahman Elshorafa says
May 3, 2019 at 1:15 pmThanks so much for useful description
Mike says
April 4, 2019 at 8:41 amso, 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
March 28, 2019 at 2:47 amIt is very helpful. Thank You
Kaustav Khatua says
March 3, 2019 at 6:42 amIt was very much helpful. Thank you.
Benjamin says
February 26, 2019 at 9:00 amThanks i tried but i failed
Hitesh says
January 19, 2019 at 3:34 amIs there a keyboard shortcut for this?
Efrem1 says
December 22, 2018 at 8:51 amThank you !
nicole says
October 21, 2018 at 11:06 pmthank you very much Mitch Bartlett for what you are doing. It is a tremendous help !