How To Add A Tab In Google Sheets

Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to add a tab in google sheets.

Large spreadsheets can get difficult to read. Scrolling through row upon row of data to find what you’re looking for can be frustrating and time consuming. Fortunately, Google Sheets allows you to break up your spreadsheet into multiple different sheets or tabs to help you organize your data and focus on what’s important. Here’s how to add a new tab:

Step 1

Click on the plus icon in the lower-left corner of the screen


Step 2

A new tab will appear to the right of the currently active tab

Step 3

By default, the new sheet will be named something like Sheet2, Sheet3, etc., depending on how many sheets are already in your spreadsheet. To rename the sheet, right click on it and choose Rename

Step 4

Then type the new name for the sheet and hit Enter. Try to pick a short but descriptive name like “Q3 Sales” or “Customer List” so you or other users can quickly identify what the tab contains in the future

Step 5

You can repeat these steps as many times as necessary to add multiple tabs to your spreadsheet


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to add a tab in google sheets. Want more? Check out all the Google Sheets Tutorials.