Keeping formulas but not data's when copying workbook?

S

Samshun

I there a way to copy a workbook without copying any data. I would like to
copy formulas without any data in the cells or notes for the cells being
copied.

I tried to put value Zero on all the cells but it's wipeout the formulas.

Thank You
 
J

Jerry W. Lewis

Edit|Goto|Special|Constants will select all cells that have data but no
formulas ...

Jerry
 
Top