Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

templates

ResolvedVersion 2003

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?

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.

Excel tip:

Toggle Formulas and Results

Ctrl + 'The key above Tab with the

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.