Excel Copy Value Not Formula. Check locked and hidden. To solve the problem select any cell in the worksheet and press f9.
After you have done that if you click on b1 and right click copy it will only copy the actual value in b1. Select a blank. Select and copy numbers which you want to paste without formulas.
To solve the problem select any cell in the worksheet and press f9.
As a precaution i like to press ctrl alt f9. Press f2 to edit the cell. As a precaution i like to press ctrl alt f9. Excel should copy the formula to c3 c6.
