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.

‍

Why do you add a tab in Google Sheets?

You may add a tab in Google Sheets for the following reasons:

1. Organize data: If you have a large dataset that you want to organize into different categories or sections, you can create a new tab for each category. For example, you can create a new sheet for output, such as, one only containing graphs and datasets for them. By generating a sheet separately you can avoid having different types of data and calculations on the same sheet.
2. Separate views: If you want to create different views of the same data, you can add tabs to separate the views. For example, you can create a new tab for a detailed breakdown of revenue, operating expenses, or Capex.
3. Collaborate: If you are collaborating with others on a shared sheet, you may add tabs to help streamline the workflow. Collaborators can easily work together on separate tabs at their paces.

‍

Why do you delete a tab in Google Sheets?

You may delete a tab in Google Sheets for the following reasons:

1. Remove unnecessary data: If you have a sheet that contains unnecessary data or information that you no longer need, you can delete the tab to remove the data from the file.‍
2. Restructure data: If you need to reorganize your data or create a new view of the data, you may need to delete a tab to achieve this objective. For example, when you realized it makes more sense to combine two tabs, once you copy and paste content from one sheet to another, you can delete the unnecessary tab.

‍

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.