Microsoft Office Tutorials and References
In Depth Information
Set the Default Number of Worksheets for New Workbooks
Set the Default Number of
Worksheets for New Workbooks
If you normally either delete existing sheets
from or add worksheets to a new workbook,
you can save time by configuring Excel to
always include your preferred number of
worksheets in each new file.
By default, Excel includes three blank
worksheets in each new workbook that you
create. However, if you never use more than a
single worksheet in most of your workbooks,
you really do not need the extra two worksheets
and may waste time deleting them.
Conversely, you might find that you always use
four, five, or more worksheets in most of your
workbooks. In this scenario, you would have
to waste time adding the new sheets to the
In both cases, you can save time by telling
Excel the number of worksheets you prefer to
have in your new workbooks.
1 Click the File tab.
2 Click Options.