Tuesday, February 23, 2010

Changing the number of worksheets in Excel 2010

When you create a new workbook, three worksheets named Sheet1, Sheet2, and Sheet3 are created by default. You can change this behaviour by changing the number of worksheets to appear. Perform the steps to do so:
1. Open Microsoft Excel.
2. Click File menu and click Options to open Excel Options dialog box.
3. By default the contents in the General section appear. Under When creating new workbooks, enter a number between 1 and 255 in the Include this many sheets: box.
4. Click OK.
/* */