excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

replyReply Thu 12 Feb 2009, 09:47Delegate janice said...

janice has attended:
Powerpoint Introduction course
Excel Intermediate course
Word Advanced course
Publisher Introduction course
Outlook Advanced course

Excel

How to set up templates and multiple worksheets?

For upcoming training course dates see: Pricing & availability

replyReply Thu 12 Feb 2009, 13:51Trainer Amanda said...

RE: 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

 

Please browse our web site to find out more about
vba for excel training and other Microsoft training courses.

Excel tip:

Seeing named ranges as part of the zoom

If you have large areas of named ranges this works better.

If you zoom down to 39% you will see your named range.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard