Excel

Hello Janice

Thank you for your question and welcome to the forum.

To create a template, set up a file so it is ready for someone to enter data into, i.e. all the labels and formulas are in place, all formatting is done.

Then when you save the file, instead of saving it as an Excel workbook (.xls), save the file as an Excel template (.xlt) file.

Your template has now been created.

I'm uncertain what you would like to know about multiple worksheets - if you have a specific question about using multiple worksheets please let me know and I'll be happy to post an additional reply to you.

Kind regards
Amanda