templates

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

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

Templates

resolvedResolved · Low Priority · Version 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:

Hide separate columns in Excel 2010

If you want to hide columns not adjacent to each other for example, Columns A, C and E then:-

1) Click on the fist column to be hidden i.e. A

2) Press and hold down the CTRL key

3) While holding the CTRL key, left click on the rest of the columns you want to hide i.e. C and E

4) Right click and choose Hide

View all Excel hints and tips


Server loaded in 0.08 secs.