Clicking insert worksheet and it brings up template

S

SGagne

Hi,

I'm working on a file that when I click "Insert, Worksheet", I then want
that worksheet to load the same exact information from Sheet 1 (which acts as
a template). How can I do this, I'm stumped.

Thanks.
 
E

Ernesto

Select the worksheet you want to work as template
Right click on it
It will pop-up a menu box
Select Move or Copy
Check the Copy box
Click ok
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top