How to copy / paste values without including formulas in Microsoft Excel: - In Microsoft Excel, if you do a normal copy and paste into a cell whose value is generated by a formula, the pasted value will contain the formula or the resulting value will not be what you want due to its dependence on the formula in the original cell. If so, you need a quick and easy solution to paste the values without including the formulas involved. This is exactly the subject of this article. So what are you waiting for? Let's get started, okay?
- Select a cell whose value is generated by a formula. In the screenshot provided I have selected the cell C5, whose value is generated by the formula = SUM (A5: B5).
- Now right click on the selected cell and press the key copy option.
- If you try to paste this value into another cell using the Paste button below Home or using the right click context menu, you can see that the copied value is not the actual value of the cell from which the value is taken. The value that is copied to the new cell is based on the formula applied to the old cell. To avoid this problem, do the following:
- Select the cell where you want to copy the value. As below, below Home click on the tab down arrow associated with Paste button. This will show an expanded set of Paste options.
- Choose one of the options below Paste the values section by simply clicking on it. Now if you look at the selected cell, you can see that it has the copied cell value and the formula is not included.
Check out the tip today to improve your Excel work. Hope you found the article useful. If you have any questions about any of the steps, feel free to leave comments, we'll be happy to help. Stay tuned for more updates on tips, tricks and tips.