This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 File Management and Recovery - Default Workbook Sheets

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.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 File Management and Recovery - Default Workbook Sheets.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.