If you haven’t changed Excel from the way it was installed, any workbooks you create will contain three worksheets. Three worksheets are plenty of room if you’re working at home and are perhaps more than you’ll need for small projects, but you’ll run out of space quickly if you’re tracking products or monthly sales. Adding or deleting a worksheet takes just a moment, but if you want to delete a worksheet, be sure you’re getting rid of the right one!
Insert a Blank Worksheet
Right-click the sheet tab of the worksheet that follows the location where you want to insert a worksheet.
Choose Insert from the shortcut menu.
Double-click Worksheet.
Tip
If you want to insert a worksheet at the end of the workbook, click the Insert Worksheet button at the right edge of the tab bar.
Delete One or More Worksheets
Hold down the Ctrl key and click the sheet tabs of the worksheets you want to delete.
Right-click the selection.
Choose Delete from the shortcut menu.
Click Delete to confirm that you want to delete the worksheet.
Caution
If you have data in the worksheet that you want to delete, deleting the worksheet will erase all the data in that worksheet. This operation is not reversible.