totn Excel 2007 Basics

MS Excel 2007: Insert a sheet

This Excel tutorial explains how to insert a sheet in Excel 2007 (with screenshots and step-by-step instructions).

Question: How do I insert a new sheet in Microsoft Excel 2007?

Answer: When you create a new document in Excel 2007, your spreadsheet will automatically be created with three worksheets called Sheet1, Sheet2, and Sheet3. You can easily add more sheets as you need them.

You can view all of the sheet names as tabs along the bottom of the document. To add a new sheet, simply click on the Insert Worksheet tab Microsoft Excel to the right of the sheet names (we have circled this tab on the image below). When you click on this tab, it will insert a new sheet at the end of the list of sheets.

Microsoft Excel

Now when you return to your spreadsheet, a new sheet should be inserted and you will be positioned on cell A1 within this new sheet. In this example, Sheet4 has been inserted into the spreadsheet. Excel will always name its sheets as Sheet1, Sheet2, Sheet3, Sheet4, and so on.

Microsoft Excel