Setting the Number of Default Worksheets

Summary: Excel allows the user to determine how many default worksheets are in a new workbook. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

When you first create a new Excel workbook, the program--by default--creates sixteen blank worksheets within the workbook. For many people, this is way too many. To alter the number of default worksheets in a new workbook, follow these steps:

Choose Options from the Tools menu. This displays the Options dialog box.
Click on the General tab. (Click here to see a related figure.)
Use the Sheets In New Workbook control to indicate how many worksheets Excel should create.
Click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2687) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.

Check out ExcelTips: Filters and Filtering today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Setting the Number of Default Worksheets