Page 37 - Excel Data Analysis

02 537547 Ch01.qxd 3/4/03 11:45 AM Page 23

GETTING STARTED WITH EXCEL 1

When you create a new blank workbook, Excel uses the default
system settings to create it — the default font settings and three
blank worksheets. Excel uses the system default settings as long
as a default workbook template does not exist. If you
consistently make changes to every new, blank workbook, you
can make a default workbook template that always loads.
To do so, you first create a workbook that contains all your
desired format settings, custom macros, formulas, and a default
number of worksheets. When you save the workbook as a
template, name it Book.xlt and save it in the XLStart folder,
which is typically located in the following location:

C:\\Program Files\Microsoft Office\Office10\
XLStart
Each time you create a new workbook, Excel uses the default
Workbook template you modified.
You can also create a default worksheet template by clicking
Insert ➪ Worksheet. You must save the worksheet template in
the same location as the workbook template, but name it
Sheet.xls. Excel copies the contents of the Sheet.xls worksheet
into your workbook each time you add a new worksheet.

■ The Templates folder › Type a name for your ■ Excel creates the specified
displays as the storage template. template.
location in the Save In field.
ˇ Click Save.

23