How to insert and delete worksheets

Let’s take a look.

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.

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

you’re free to add as many worksheets to a workbook as you like.

The number of worksheets is limited only by available memory.

Once the cursor changes to a double-headed arrow, just click and drag to resize.

you could also navigate tabs using the controls to the left.

To delete a worksheet, just right-grab the tab and choose Delete from the menu.

Holding down the control key, you might select more than one tab at a time.

Then, you’re free to delete all selected worksheets in one step.

you could also delete worksheets 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.