
Tips.Net > ExcelTips Home > Worksheets > 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:
Tip #2687 applies to Microsoft Excel versions: 97 2000 2002 2003
More Power! Expand your skills and make Excel really sing! It's all possible with macros. The best resource anywhere for macros is ExcelTips: The Macros. Check it out today!
No, not that type of date. If you need to do any types of work with calendar dates, Excel has the tools you need. Learn how to use those tools the easy way. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site