How to Create Spreadsheets in Excel 2007
- 1). Open Excel 2007. The three spreadsheets that are created by default are labeled "Sheet 1," "Sheet 2" and "Sheet 3."
- 2). Click the "Insert Worksheet" button. The button is located to the right of the "Sheet 3" tab. A new spreadsheet will open that is labeled "Sheet 4." Repeat this to insert additional sheets.
- 3). Right-click over a spreadsheet tab and click "Insert" from the menu that pops up to create a spreadsheet using a different method. Select "New Worksheet" when the "Insert" dialog box opens. A new spreadsheet will be created.
- 4). Create multiple spreadsheets at once by holding down the "Shift" key and highlighting the existing spreadsheet tabs in your workbook. Highlight the number of spreadsheets you want to create. For example, if you want to create two additional spreadsheets, highlight two spreadsheet tabs. Click the "Home" tab from the Excel ribbon at the top of the page and look to the "Cells" section. Click the "Insert" button and select "Insert Sheet" from the drop-down menu. The spreadsheets will be added to your workbook.
Source...