Remove the formulae, but keep the data

D

Dave Womack

I have an "entry" sheet which feeds a "Finished" sheet. I want to send the
finished one to a client without revealing how I came up with the numbers.
How do I delete the formulae, but keep the data?
 
D

Dave Womack

Teethless mama said:
Select your formula > hit F2 > hit F9

Thanks. this in not exactly what I was looking for, but a neat trick. I
really appreciate your quick response. Ron (above) gave me what I was
looking for.

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top