How to Add and Delete Worksheets in Excel:

When you are working in Excel, sometimes you may need to add a new worksheet to enter more data.

You may also have worksheets that you no longer need and want to delete them.

Excel gives you a few simple ways to add and delete worksheets.

In this guide, let’s see how to add and delete worksheets in Excel step by step.

Video Tutorial:

What Is a Worksheet in Excel?

Before we start, let’s quickly understand what a worksheet means.

A worksheet is an individual sheet inside an Excel workbook.

For example:

Sales Report.xlsx → Workbook

Sheet1 | sheet2 | sheet3 → Worksheets inside the workbook

You can add multiple worksheets to the same workbook and use each worksheet for different data.

How to Add a Worksheet in Excel?

There are several ways to add a new worksheet.

Let’s look at them one by one.

Method 1: Add a Worksheet Using the + Button

The easiest way to add a new worksheet is by using the + button.

You can find this button next to the worksheet tabs at the bottom of Excel.

Follow these steps:

1. Open your Excel workbook.

2. Go to the worksheet tabs at the bottom.

3. Click the + button.

4. Excel will add a new worksheet.

The new worksheet will appear next to the current worksheets.

If you want another worksheet, click the + button again.

You can continue clicking it to add more worksheets one by one.

Method 2: Add a Worksheet Using the Home Tab:

You can also add a worksheet from the Home tab on the Excel Ribbon.

Follow these steps:

1. Open Excel.

2. Go to the Home tab.

3. In the Cells group, click the Insert drop-down.

4. Select Insert Sheet.

Excel will add a new worksheet to the workbook.

Can You Add Multiple Worksheets at Once?

Yes. You can add multiple worksheets in one go.

If you want to add 2 worksheets, select 2 already available worksheets in Excel and follow the above steps. Now another 2 worksheets will be added to your workbook.

Example:

Suppose your workbook already has three worksheets:

Sheet1 | Sheet2 | Sheet3

First select two worksheets and then use:

Home → Insert → Insert Sheet

Excel will add two new worksheets.

This is useful when you need to add several worksheets at once.

Method 3: Add a Worksheet Using a Keyboard Shortcut

If you prefer using keyboard shortcuts, Excel gives you a quick way to insert a new worksheet.

Press:

Shift + F11

Excel will immediately create a new worksheet.

Add Multiple Worksheets at Once:

What if you want to add several worksheets instead of adding them one by one?

You can do that too.

Steps:

1. Hold the Ctrl key and click the worksheet tabs to select multiple sheets.
2. Once the required sheets are selected, press Shift + F11.

Excel will insert the same number of new worksheets as the number of worksheets you selected.

Example:

If you select 2 worksheets and press:

Shift + F11

Excel will add 2 new worksheets.

This can save you time when you need to create several sheets at once.

How to Delete a Worksheet in Excel?

If you no longer need a worksheet, you can delete it from the workbook.

There are several ways to do this as well.

Delete a Worksheet using the Worksheet tab:

This is probably the easiest way to delete a worksheet.

Follow these steps:

1. Go to the worksheet tabs at the bottom of Excel.

2. Right-click the worksheet you want to delete.

3. Select Delete.

4. Excel will remove the worksheet from the workbook.

Important:

If the worksheet contains data, Excel may display a warning asking you to confirm the deletion.

Once you delete a worksheet, its data is also deleted.

So, make sure you are deleting the correct worksheet.

Can You Delete Multiple Worksheets at Once?

Yes.

You can select multiple worksheets and delete them together.

For example, if you want to delete 3 worksheets, select those worksheet tabs first.

Then:

Right-click → Delete

Excel will delete all the selected worksheets.

Delete a Worksheet using the Home tab:

You can also delete a worksheet from the Home tab.

Follow these steps:

1. Select the worksheet you want to delete.

2. Go to the Home tab.

3. In the Cells group, click the Delete drop-down.

4. Select Delete Sheet.

The selected worksheet will be deleted from the workbook.

You can also select multiple worksheets first and use the same option to delete them together.

What Happens When You Delete a Worksheet?

When you delete a worksheet, Excel removes the entire sheet from the workbook.

This means the worksheet’s:

• Data
• Formulas
• Formatting
• Charts
• Other content

will be removed along with the worksheet.

So, always check the worksheet before deleting it.

Can You Undo a Deleted Worksheet?

This is an important point to remember.

After deleting a worksheet, you may not be able to use Ctrl + Z to restore it in the same way you would undo a normal cell edit.

So before deleting an important worksheet, make sure you really don’t need it.

If the data is important, it’s a good idea to keep a backup copy of the workbook first.

Note: Want to learn how to change the worksheet name or move a worksheet to another place? Check out our guides on How to Rename a Worksheet in Excel and How to Move and Copy Worksheets in Excel.

Frequently Asked Questions:

How do I add a new worksheet in Excel?

You can click the + button next to the worksheet tabs, use Home → Insert → Insert Sheet, or press Shift + F11.

What is the shortcut to add a worksheet in Excel?

Press:

Shift + F11

Excel will add a new worksheet to the workbook.

Can I add multiple worksheets at once?

Yes.

You can select multiple existing worksheets and use Home → Insert → Insert Sheet or press Shift + F11 to add the same number of new worksheets.

How do I delete a worksheet in Excel?

Right-click the worksheet tab and select Delete.

You can also use:

Home → Delete → Delete Sheet

Can I delete multiple worksheets at once?

Yes.

Select the worksheets you want to delete, right-click one of the selected tabs, and choose Delete.

Can I recover a deleted worksheet?

No.

What is the difference between a workbook and a worksheet?

A workbook is the Excel file itself.

A worksheet is an individual sheet inside that workbook.

For example:

Sales Report.xlsx → Workbook

January, February, March → Worksheets

Final Thoughts:

Adding and deleting worksheets is one of the basic Excel skills you will use regularly.

The easiest method is to click the + button whenever you want to add a new sheet.

And when you want to work faster, remember this keyboard shortcut:

Shift + F11 → Add a new worksheet

For deleting a worksheet, simply right-click the sheet tab → Delete.

Once you become comfortable with worksheet tabs, managing large Excel workbooks becomes much easier.

Related Excel Guides:

How to Rename a Worksheet in Excel