email spreadsheet without formulas

[Lawrence Dodge]

Hi all -

I have a rather large spreadsheet with LOTS of equation. I would like to email just one worksheet to a client with no equation available and only the numbers / values in the cells. Any thoughts?

thanks

Lawrence

 

[Luke M]

Right click the sheet tab, Copy. Change the options to copy the one sheet to a new workbook. Then, Select all the cells in the single sheet, copy.

Right click, paste special, Values.

This will remove all formulas so be sure you're saving the single sheet as a new name, and not over writing something important.

 

[Lawrence Dodge]

thank you much that should do it

 

[Luke M]

You're very welcome, glad I could help. =)