Tracey has attended:
Excel Intermediate course
How do I paste formulae to show the values?
How do I paste formulae to show the values?
RE: How do I paste formulae to show the values?
Hi Tracey,
Thanks for the question.
To copy only the values of the cells instead of the formulas, simply go into the Edit menu and press copy as you normally would then when you go to paste click the "Paste Special" option on your edit menu and tick against the Value option.
I hope that answers your question, feel free to get back to me if there is anything else
Tracy