Inserting and Deleting a Worksheet

You can add or delete sheets in a workbook. If, for example, you are working on a project that requires more than three worksheets, you can insert additional sheets in one workbook rather than open multiple workbooks. You can insert as many sheets in a workbook as you want. If, on the other hand, you are using only one or two sheets in a workbook, you can delete the unused sheets to save disk space. Before you delete a sheet from a workbook, make sure you don't need the data. You cannot undo the deletion.

Insert a Worksheet

Click the sheet tab to the right of where you want to insert the new sheet.

Click the Insert menu, and then click Worksheet.

A new worksheet is inserted to the left of the selected worksheet.

Delete a Worksheet

Click the sheet tab of the worksheet you want to delete.

Click the Edit menu, and then click Delete Sheet.