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

[Guest]

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?

 

[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

*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)