templates
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 » Templates

Templates

resolvedResolved · Low Priority · Version 2003

replyReply Wed 10 Nov 2010, 16:27Delegate Minna said...

Minna has attended:
Excel Introduction course
Excel Intermediate course

Templates

How to insert a template on a new worksheet rather than a whole new workbook?

For upcoming training course dates see: Pricing & availability

replyReply Mon 15 Nov 2010, 22:06Trainer Anthony said...

RE: Templates

Hi Minna, thanks for your query. Unfortunately Excel templates are .xlt files which apply to whole workbooks, so they can't be applied to a single sheet. However, what you could do is copy a formatted "template" worksheet to the file in question. Just right click on it and chose "Move or Copy" and then tick the "Create a copy" tickbox, sending it to your file or an entirely new workbook. That's probably the easiest way to insert a pre-formatted worksheet into a workbook of your choice.

Hope this helps,

Anthony

Mon 22 Nov 2010: Automatically marked as resolved.

 

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

Excel tip:

Selecting your working range

In excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working 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