I want to copy only the layout and formulas and not the exisiting

E

edv

I want to copy an exisiting worksheet with all the formulas and layout but
don't want to take all the data contained within the sheet so that I can
resuse the existing layout? Any ideas?
 
M

Max

Depending on your actual sheet layout, this might be workable ...

After you copy over the entire sheet, you can press F5 > Special > Constants
OK to select the data*. Then clear with the Delete key
Click to expand...
*includes col/row labels etc, if any, unfortunately

And then re-copy > paste over the col labels as required (< this is the part
which might prove a bit tedious to do)
 
Top