HomeMicrosoft OfficeMicrosoft ExcelExcel 2007: Change the Number of Worksheets in Your New Workbooks

Excel 2007: Change the Number of Worksheets in Your New Workbooks

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.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

LATEST REVIEWS

Recent Comments

error: Content is protected !!