A complex Excel 2007 workbook could require multiple sheets. By default, Microsoft provides three sheets on each workbook, but you can add as many as you need. Clicking the "Insert Worksheet" button quickly adds a single sheet, but if your business workbook requires numerous sheets, adding sheets one at a time can become tedious. Instead, Excel allows you to add multiple sheets simultaneously. You are limited by the number of sheets you currently have, but you can repeat the process to add an increasing number of sheets.
Click the first tabbed sheet at the bottom of the Excel window. By default, this will be "Sheet1."
Hold the "Shift" key and click the nth sheet, where "n" is the number of sheets you need. As an example, if you needed to add three sheets on a newly created workbook, hold "Shift" and click "Sheet3" to select the first three sheets. If you already have more sheets than are visible, click the arrows to the left of the sheet tabs to scroll through them.
Click the "Home" tab, "Insert" in the Cells group and select "Insert Sheet" to add the same number of sheets as you currently have selected. If you need more sheets than this, repeat the process. By repeating, you can increase the number of sheets you can add at a time. As an example, there are only three sheets to select on a new workbook, so you can only add three new sheets. However, you then have six sheets, so you can add six more the next time. Each time you repeat the process, you can double the number of sheets you have.