How to Change the Number of Default Sheets in an Excel Workbook

When you start Excel chances are it loads in three blank worksheets as a default. Did you know you can change that to whatever number you want? Here are those steps.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Excel

1. Open Excel

2. 
   Tools

   Click the "Tools" menu item located at the top of the screen.

3. 
   Options

   Click the "Options" submenu item.

4. 
   General Tab

   On the options window that appears, click the "General" tab. It is circled in red in the picture.

5. 
   Sheets in a Workbook

   Halfway down the Options window under the tab "General", locate the item labeled, "Sheets in a new Workbook". Change that number to whatever number you want. It is circled in red in the pictured.

6. Close Excel

7. 
   New sheet count

   Open up Excel again and verify that the number of sheets that it starts with is the same number that you entered in step 5.

Resources

• Click here to receive all of my How-To articles via email.