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.

‍

What are other tips on tabs you should learn?

These three articles are helpful if you are a beginner and need to learn how to insert and remove a tab or move to a different worksheet in a file.

How to Duplicate a Sheet in Google Sheets

How to Switch Tabs in Google Sheets

How to Move Tabs in Google Sheets

‍

The following three articles are beneficial when you have many worksheets in a file and want to make them neat or highlight specific tabs.

How to Rename a Sheet in Google Sheets

How to Hide a Tab in Google Sheets

How to Change Tab Color in Google Sheets

‍

You can learn about other Google Sheets formulas and tips that are not mentioned here on this page: LiveFlow‘s How to Guides

‍

Analyze your live financial data in a snap

Are you learning this formula to visualize financial data, build a financial model, or conduct financial analysis? In that case, LiveFlow may help you automate manual workflows and update numbers in real-time. You can access various financial templates on our website, from the simple Income Statement to Multi-Currency Consolidated Financial Statement. You can also customize these templates as you want without breaking the automated data inflow.

To learn more about LiveFlow, book a demo.