Excel 2000 in a Nutshell

Name

Insert → Worksheet

Synopsis

When Excel creates a new workbook there are three worksheets that are added by default, unless you change the default setting by selecting Tools → Options and specifying a different number on the General tab (refer to Chapter 8). You can add additional worksheets to your workbook at anytime using Insert → Worksheet. If you want to add more than one, simply hold down the Ctrl key and click on the desired number of worksheet tabs before selecting this option.

When you add new worksheets to a workbook, Excel simply adds each new worksheet in front of the currently selected sheet. You can rearrange the order of the worksheets with Edit → Move or Copy. When you use the Edit → Move or Copy option, you are able to specify the exact order for the sheets currently available in the workbook.

Keep in mind you can customize the properties of the sheet that is added to your workbook by creating a worksheet template called sheet.xlt and placing it in the XLStart folder. To create a worksheet template, take a workbook and delete all but one worksheet. Make the desired modifications to the worksheet such as name of worksheet, column widths, named styles, etc. You can even place text on the worksheet template. Once you create you worksheet template, place it in one of the default template locations:

• C:\windows\Profiles\user_name\Application Data\Microsoft\Templates.

• The XLStart folder where Excel looks for the book.xlt template used to create workbooks when you ...