When you open a new workbook in Microsoft Excel, three worksheets labeled Sheet1, Sheet2, and Sheet3 appear. You can change this default setting by performing the following steps:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button
and click Excel Options.
3. From the Excel Options dialog box, in the Popular tab, under When creating new workbooks section, enter a number in the Include this many sheets: box.
4. Click OK.
Note:
The maximum allowed number is 255. In other words you can have 255 empty worksheets when you create a new workbook in Excel 2007.
1. Open Microsoft Excel.
2. Click the Microsoft Office Button
and click Excel Options.3. From the Excel Options dialog box, in the Popular tab, under When creating new workbooks section, enter a number in the Include this many sheets: box.
4. Click OK.
Note:
The maximum allowed number is 255. In other words you can have 255 empty worksheets when you create a new workbook in Excel 2007.
0 comments:
Post a Comment