How to Add and Delete a Tab in Google Sheets

In this article, you will learn how to add and delete a sheet in Google Sheets.

‍

How to add a new sheet in Google Sheets

One way to add a new sheet is as follows:

1. Go to the bottom left corner of the existing sheet.
2. You should see the “+” icon there.
3. Click the icon, and you will create a new worksheet.

‍

‍

How to add a new sheet in Google Sheets

‍

You can take the following approach as well:

1. Go to the “Insert” tab in the top menu.
2. Choose “Sheet” in the pull-down menu, and you see a new worksheet.

‍

‍

In addition to the two ways above, you can use a shortcut key to insert a new sheet.

Simply press “Shift” and “F11” for Windows or “Shift”, "Fn", and “F11" for Mac.

‍

How to delete a new sheet in Google Sheets

1. Go to the bottom part of your window.
2. Put your cursor on a tab of a sheet you want to delete.
3. Right-click and choose “Delete.”
4. A pop-up shows up and asks if you need to delete the sheet.
5. Click “OK” if you want to go ahead and “Cancel” if you want to cancel the deletion.

‍

‍

How do you select multiple sheets?

1. Go to the tab of the first sheet and click it.
2. Press the Ctrl key on your keyboard if you're using a PC on Windows and press Command on Mac.
3. For selecting non-adjacent tabs, while holding down the Ctrl or Command key, left-click the sheets you want to select. For selecting adjacent tabs, while holding down the Shift key, left-click the sheet at the end of the range you want to select.
4. And if you right-click (while holding down the Ctrl key or Command key), a menu pops up for further action (e.g., duplicating or hiding the selected sheets).

‍

How do you delete multiple sheets?

1. Select the sheets you want to delete (as explained above).
2. Choose “Delete” in the pop-up option.