Change the Number of Worksheets in Your New Workbooks

By | 2007-01-24

By default, Excel creates three worksheets in each new workbook that you create. If you prefer to reduce or increase this behavior to better meet your needs, follow these instructions.

1. Click the Office Button.

2. Click the Excel Options button.

3. Select Popular from the left pane.

4. Under the When creating new workbooks section, change the value for Include this many sheets to the number of worksheets you want made to all new workbooks.

5. Click OK.

Author: dwirch

Derek Wirch is a seasoned IT professional with an impressive career dating back to 1986. He brings a wealth of knowledge and hands-on experience that is invaluable to those embarking on their journey in the tech industry.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.