|
Did you know you can create a single sheet template and insert it into any excel workbook?
Think of the possibilities—the worksheet contains all the necessary information you need including formulas, borders, fill colours, etc. All you have to do is right-click on any sheet tab in any workbook and choose insert. From the choices available, you simply select one of your templates.
Here’s how to create it.
Open a new blank workbook and delete all but one worksheet. Enter all the data you need on the sheet and format the cells accordingly. This can include headers & footers, formulas, borders, fill colours, cell formatting ($$ or text etc.), alignment, column widths, row heights and so on and so on...
When it is time to save it, use File, Save As and choose Document Template (.xlt) from the “Save as type” drop down menu at the bottom of the screen. Make sure the name you use is something obvious and relevant so it is easy to spot this template when you need it. It must be saved in the Microsoft default Templates folder in order for it to appear on the “General tab” when you right-click and choose Insert.
Now whenever you want to use this sheet, you can simply insert it. No need to try to copy it to another workbook or, (even worse) try to copy and paste the whole thing.
Donna Harwood, The Office Tutor
www.theofficetutor.com
|
