by Allen Wyatt
(last updated June 14, 2016)
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:
Figure 1. The General tab of the Options dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2687) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
Your workbooks can contain many, many worksheets. Which of those worksheets are the largest, however? Here's some ideas ...Discover More
If you need to save your Excel data at different benchmarks, you might want to use some sort of "versioning" system. Such ...Discover More
Excel makes copying worksheets (duplicating them) rather easy. However, you may want a worksheet copy that differs from ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.