How to add a new sheet in Google Sheets

Learn how to add, rename, duplicate, and organize new sheets in Google Sheets on desktop and mobile, including shortcuts and templates.

Quick answer

To add a new sheet in Google Sheets, click the plus (+) icon at the bottom-left corner of your spreadsheet window, next to the existing sheet tabs. A new blank tab appears instantly, labeled Sheet2 (or the next available number), and you can rename it by right-clicking its tab and choosing Rename.

Steps at a glance

  1. Open your spreadsheet and locate the sheet tabs at the bottom.
  2. Click the plus (+) icon to add a blank sheet.
  3. Rename the new tab: right-click it and choose Rename.
  4. Right-click a tab to duplicate, delete, or reorder sheets.
  5. Try the Insert menu as an alternate way to add sheets.

Interactive demo

Loading demo…

Summary

Adding a new sheet lets you split data, reports, or categories into separate tabs within one Google Sheets file. It's a core organizational skill that keeps large workbooks readable and makes it easier to find, filter, or share specific information.

Step-by-step guide

  1. Step 1

    Open Your Spreadsheet

    Open the Google Sheets file where you want to add a new sheet, either from Google Drive or your browser's recent files list. Make sure you're signed into the Google account that owns or has edit access to the file.

  2. Step 2

    Click the Plus Icon to Add a Sheet

    At the bottom-left of the spreadsheet window, find the row of sheet tabs. Click the plus (+) icon just to the right of the last tab to instantly insert a new, blank sheet labeled Sheet2, Sheet3, and so on.

  3. Step 3

    Rename the New Sheet

    Right-click the new tab at the bottom of the screen and choose Rename to make its name editable, then type a descriptive title like 'January Data' or 'Summary.' Press Enter to save the new name, which helps you stay organized as your workbook grows.

  4. Step 4

    Try the Insert Menu Alternative

    You can also add a sheet through the menu bar: click Insert, then choose Sheet from the dropdown list. This method works the same as the plus icon but is useful if you prefer navigating menus over hunting for small icons.

  5. Step 5

    Duplicate an Existing Sheet Instead

    If you want to reuse formatting, formulas, or a filter setup from another tab, right-click that sheet's tab and select 'Duplicate.' This creates a copy named 'Copy of Sheet Name' that you can rename and edit without disturbing the original — handy when you've already built a filtered view using create a filter and want the same structure elsewhere.

  6. Step 6

    Organize, Color, and Reorder Tabs

    Right-click any sheet tab to access options for changing its color, protecting it, or moving it. Use Move left or Move right to reorder them, keeping related sheets — like raw data and a sorted summary from sorting a table — grouped together.

Why this matters

You're building a budget tracker and need to separate monthly data without cluttering one tab. Adding a new sheet lets you organize raw numbers, summaries, and charts into clean sections, so anyone reviewing your spreadsheet finds exactly what they need instantly.

Frequently asked questions

  • What's the keyboard shortcut for adding a new sheet?

    Press Shift+F11 on Windows or Mac (it's listed next to Insert > Sheet) to insert a new blank sheet without touching your mouse.

  • Does adding a new sheet change sharing permissions?

    No. Sharing is set for the whole file, so a new tab gets the same access as every other tab. To stop edits on one tab, right-click it and choose Protect sheet.

Create interactive demos like this one — free, no coding required.

Start for free →