Keeping formulas but not data's when copying workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Edit|Goto|Special|Constants will select all cells that have data but no
formulas ...

Jerry
 
Back
Top