Change the Number of Worksheets in Your New Workbooks

Posted On 2007-01-24 by FortyPoundHead
Keywords: Excel 2007
Tags: Tip Windows
Views: 1575

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.

About the Author

has posted a total of 1974 articles.

Comments On This Post

No comments on this post yet!

Do you have a thought relating to this post? You can post your comment here. If you have an unrelated question, you can use the Q&A section to ask it.

Or you can drop a note to the administrators if you're not sure where you should post.

Your IP address is:

Before you can post, you need to prove you are human. If you log in, this test goes away.

Code Links