Inserting and Deleting Worksheets in Excel- Instructions

Inserting and Deleting Worksheets in Excel: Video Lesson

            This video, titled “Inserting and Deleting Worksheets,” shows different ways of inserting and deleting worksheets in Excel. This video is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.”

Inserting and Deleting Worksheets in Excel: Overview

            In this tutorial, you will learn about inserting and deleting worksheets in Excel. Inserting and deleting worksheets in Excel is a critical skill to possess when working with Microsoft Excel workbooks.

            To insert a single new worksheet to the right of the currently selected worksheet, click the “New Sheet” button at the right end of the spreadsheet name tabs. Alternatively, you can also click the “Insert” drop-down button in the “Cells” button group on the “Home” tab of the Ribbon. Then select the “Insert Sheet” command from the drop-down menu. Alternatively, you could also press the keyboard shortcut of “Shift” + “F11” on your keyboard to automatically insert a new worksheet. If using these last two methods, however, note that Excel inserts the new worksheets to the left of the active worksheet. This is the worksheet whose name tab appears in color and bolded when the sheet is inserted.

Inserting and Deleting Worksheets in Excel- Instructions: A picture of a user inserting a new worksheet into an Excel workbook.

            Deleting old worksheets that you no longer use can reduce worksheet clutter in workbooks. To delete worksheets in Excel, select the worksheet name tabs of the sheet or the sheets to delete. Then click the “Delete” button in the “Cells” button group on the “Home” tab of the Ribbon. Then click the “Delete Sheet” command in the button’s drop-down menu to delete the selected worksheets.

Inserting and Deleting Worksheets in Excel: Instructions

1. To insert a single new worksheet to the right of the currently selected worksheet, click the “New Sheet” button at the right end of the spreadsheet name tabs.
2. Alternatively, click the “Insert” drop-down button in the “Cells” button group on the “Home” tab of the Ribbon.
3. Then select the “Insert Sheet” command from the drop-down menu.
4. Alternatively, press the keyboard shortcut of “Shift” + “F11” on your keyboard to automatically insert a new worksheet.
5. If using one of these last two methods, however, note that Excel inserts the new worksheets to the left of the active worksheet. This is the worksheet name tab which appears in color and bolded when a new sheet is inserted.
6. To delete worksheets in Excel, select the worksheet name tabs of the sheet or the sheets to delete.
7. Click the “Delete” button in the “Cells” button group on the “Home” tab of the Ribbon.
8. Then choose the “Delete Sheet” choice in the button’s drop-down menu.