how to have result of excell formula remian as if inputed

J

jim miller

having made a spreadwheet with formula. results are reflected. how to kave
the result follow when copying and posting worksheet to another workbook as
if the results was initially inputed.
 
D

Dave Peterson

I _think_ that you'd want to
Edit|Copy the cell
select the new location
Edit|Paste special|Values

But the formula won't be pasted--just the results of the formula.
 
Top