Too Many Sheets?


By default, each new Excel workbook begins life with three worksheets. You can, of course, add more sheets to the workbook or delete sheets you don't need. The unused sheets don't occupy additional memory or increase file size, but I generally don't like them in my workbooks. A better approach is to change the default. Select ToolsòOptions and click General in the Options dialog box. Then change the setting for 'Sheets in new workbook'. Now all new workbooks will have the number of sheets you specified.

- John Walkenbach


Category:Spreadsheets
Issue: July 2000

These Web pages are produced by Australian PC World © 2000 IDG Communications