Welcome toExcel.Tips.Net
Helpful Links
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Newest Tips
Assigning a Macro to a Keyboard Combination
Hiding Rows Based on a Cell Value
Subscribe
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)
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
Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!Check out ExcelTips Archives today!