Exceljet

Quick, clean, and to the point

How to insert and delete worksheets

In this lesson, we'll look at how to insert and delete worksheets in an Excel workbook.

Let's take a look.

The easiest way to add a new worksheet to a workbook is to click the Insert Worksheet tab that sits to the right of the last tab in the workbook.

When you click this button, Excel will immediately add a new worksheet to the workbook, at the right of the last worksheet. No matter which tab is selected, the new worksheet goes to the end of the list.

Note that there is a keyboard shortcut for adding a new worksheet, Shift F11.

Another way to add a new worksheet is to select Insert Sheet, from the Insert menu, on the home tab of the ribbon.

This command always inserts new worksheets to the left of the currently selected worksheet.

You can add as many worksheets to a workbook as you like. The number of worksheets is limited only by available memory.

When you add a lot of worksheets to a workbook, you may want to adjust the area available to display tabs. You can do this by grabbing the small handle to the right of the tab display area. Once the cursor changes to a double headed arrow, just click and drag to resize.

You can also navigate tabs using the controls to the left. You can use the arrow keys, or you can right click these controls to display a list of tabs, then select the tab you'd like to move to.

To delete a worksheet, just right click the tab and choose Delete from the menu. You can control click tabs to select more than one at a time, to Delete more than one worksheet at a time.

You can also delete sheets using the Delete menu on the home tab of the ribbon. Choose Delete Sheet from the menu.

Note that there is no undo for deleted sheets. When you delete a worksheet, it's permanent, so be careful.

If you've accidentally deleted a sheet, but have saved your workbook recently. You might want to close the file and re-open the saved workbook.

Course 
Core Excel

Related shortcuts

ShiftF11
fnF11
CtrlClick
Click
Author 
Dave Bruns