Excel Copy Value Not Formula. Method 1 use copy and paste special values. 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. Immediately every formula in the file is updated. After you have done that if you click on b1 and right click copy it will only copy the actual value in b1.
The reason this happened was because excel was set to manual recalculation.
Immediately every formula in the file is updated. Then click the values option under paste option item in the context menu see. Then you will see all numbers are pasted in the destination cells without formulas. Then protect the sheet.
