Specifying the Number of Sheets in a New Workbook

When you create a new workbook in Excel, the file comes with three worksheets by default. Most people just use one worksheet, but leave the other two sheets in the workbook, just in case. If you use several sheets in many or all of your workbooks, you should consider increasing the default number of sheets that Excel includes in new workbooks. Follow these steps:

1. Choose Office, Excel Options to open the Excel Options dialog box.

2. Click Popular.

3. Use the Include This Many Sheets spin box to set the number of sheets you want by default.

That's fine if you always use lots of sheets, but what if you use lots of sheets only occasionally? In that case, it would be nice to be able to specify the number of sheets you want as you're creating a new workbook. The macro in Listing 8.4 enables you to do just that.

0 0

Post a comment