Excel ships with a relatively customisable interface, particularly via the Tools>Options... menu and the Tools>Customize... menu. Most things in these two areas is persistent despite the workbook opened and, of course, most settings you make in a particular workbook are saved and re-opened with it. However, you will often find yourself making many settings regularly to suit your own purposes. If you would like these to always be the settings you need to set up two templates.
- Book.xlt (or Book.xltx in Excel 2007) - This should be a workbook, saved as an Excel template called book.xlt or book.xltx in XL2007, with all the settings you want made to it, number of sheets, page headers/footers, styles, etc. This should be saved to a special folder, (which may be hidden), called XLStart. This folder is set up during Excel installation and anything in here is started when Excel is. The book.xlt (or xltx) file will start, instead of the 'built-in' version with Excel's default settings.
- Sheet.xlt (or Sheet.xltx in Excel 2007) -
This should be a single-sheeted workbook, saved in the same way and to the same folder, but with the name sheet.xlt (or sheet.xltx in XL2007). This should have all the changes made to your book.xlt (or .xltx). This will ensure that any sheets added to a workbook will have the same look and feel as the main template.
Posted
Jan 03 2008, 06:18 PM
by
Nick Hodge