Making a worksheet a templete

G

Guest

Is there a way to make a worksheet a templete? In other words locking certain
cells so that the data around it can be deleted but not the protected cell?
Enabling one to select all and then delete without losing the form?
 
G

Guest

I just so happened to have seen that in another post and printed it out:

Open a New Workbook, delete all but one sheet.
Format as you wish.
File>Save As>File Type>Excel Template(*.xlt)
Name it SHEET and store it in your XLSTART folder.
It will become the Insert>Worksheet default sheet.
Shift + F11 will insert a new sheet.

Hope this is what you were tallking about!
 

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