![]() Kutools for Excel: with more than 300 handy Excel add-ins, free to try with no limitation in 30 days.Īfter installing Kutools for Excel, please do as follows:ġ. With above method, you may lose the cell formatting, if you like to paste without formulas but keep the cell formatting, Kutools for Excel’s To Actual utility may do you a favor. Note: Paste Special command clears not only formulas, but also formatting, such as bold, color, etc. Then you will see all numbers are pasted in the destination cells without formulas. ![]() ![]() Then click the Values option under Paste Option item in the context menu, see the following screen shot:ģ. Select and copy numbers which you want to paste without formulas.Ģ. If you just want to copy the calculated results without copying their formulas, you can use Paste Special command as follows to copy numbers without copying formulas, but it will clear any formulas and formatting.ġ. ![]() This article will guide you to copy the calculated results of formulas without changing values in Excel.Ĭopy numbers or values without copying formulas in cells with Paste Special commandĬopy numbers or values without copying formulas in cells with Kutools for ExcelĬopy numbers or formulas without changing cell references with Kutools for Excel When you copy numbers that are calculated results of formulas to other cells, those numbers will be changed after you pasting, because normally you copy those formulas instead of their calculated results. How to copy numbers or values without formulas in Excel?
0 Comments
Leave a Reply. |