Try the Excel Course for Free!

Inserting and Deleting Worksheets in Excel- Instructions

/ / Excel 2013, Excel 2016, Excel 2019, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365
Inserting and Deleting Worksheets in Excel- Instructions: A picture of a user inserting a new worksheet into an Excel workbook.

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.

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.

Inserting and Deleting Worksheets in Excel: Video Lesson

            You can watch the following video lesson, titled “Inserting and Deleting Worksheets,” to learn different methods of inserting and deleting worksheets in Excel. This video is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.”

TOP
Extra 30% Off Store-Wide 0 Days 2 Hours 36 Minutes 28 Seconds      Use Coupon: EXTRA30
Shop Now