Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 File Management and Recovery

Default Workbook Sheets

Summary: Modify the default number of worksheets in a new Microsoft Excel 2003 workbook.

Whenever you create a new workbook in Microsoft Excel 2003, three worksheets are provided for the workbook. You can jump back and forth between them by clicking on the tabs at the bottom of the current worksheet.

However, for some, this default is an annoyance. Many people prefer to have one worksheet per file, so they must manually remove the extra worksheets every time they create a new workbook.

Yet others use this feature extensively and always have at least 5, 6, or more worksheets per file.

Either way, if you do not like this default Excel 2003 setting, you can easily change it:

1. Click "Tools" - "Options".
2. When the "Options" multi-tabbed dialog box appears, click the "General" tab.
3. Next to "Sheets in new workbook" enter a number from 1 - 255 as desired.
4. Click "OK" to close the dialog box.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 3:23 P.M. EDT

Return to the Microsoft Excel 2003 File Management and Recovery page.

Print this tip.

- Subscribe!

Search the Site: