Excel Digest

  Excel help for the rest of us

08 Jun

Change the number of the default worksheets

When you open an Excel workbook, by default Excel provides three worksheets named sheet1, sheet2 and sheet3 respectively.

You can change this number to your needs as follows:

  1. On the Tools menu click Options.
  2. On the Options window click the General tab.
  3. Next to ‘Sheets in new workbook’ enter the number of sheets you want.
  4. Click OK.

Applies to: Excel 2003

Print This Post Print This Post

Related Posts

   
How to change Excel default file location 
Change the number of the recently used workbooks 
How to change worksheet tab color 

Leave a Reply

© 2008 Excel Digest | Entries (RSS) and Comments (RSS)

GPS Reviews and news from GPS Gazettewordpress logo