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 double-clicking its tab name.
Steps at a glance
- Open your spreadsheet and locate the sheet tabs at the bottom.
- Click the plus (+) icon to add a blank sheet.
- Rename the new tab by double-clicking its label.
- Right-click a tab to duplicate, delete, or reorder sheets.
- Try the Insert menu as an alternate way to add sheets.
- On mobile, tap the plus icon or use the three-dot menu.
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
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.
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.
Step 3
Rename the New Sheet
Double-click the new tab's name at the bottom of the screen to make it 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.
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.
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 'Sheet Name (copy)' 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.
Step 6
Organize, Color, and Reorder Tabs
Right-click any sheet tab to access options for changing its color, protecting it, or moving it. Drag tabs directly with your mouse to reorder them, keeping related sheets — like raw data and a sorted summary from sorting a table — grouped together.
Step 7
Add Sheets on Mobile
In the Google Sheets mobile app, tap the plus (+) icon at the bottom-right corner of the screen while viewing your spreadsheet, or tap the three-dot menu near the sheet tabs and select 'New sheet.' Rename it by tapping the tab name twice and entering a new title.
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 Fn+Shift+F11 on some Mac keyboards, to insert a new blank sheet without touching your mouse.
Can I create a new sheet from a template?
Yes. Open File, then New, then From template gallery to start a spreadsheet with a pre-built layout, and add extra blank sheets to it afterward using the plus icon.
How many sheets can one spreadsheet hold?
Google Sheets allows as many sheets as your file's overall cell limit permits, currently around ten million cells total, so most users can add dozens of tabs without hitting a limit.
Does adding a new sheet change sharing permissions?
No. All sheets within one spreadsheet file share the same permissions, so anyone with edit access to the file can add, rename, or delete any tab.
Create interactive demos like this one — free, no coding required.
Start for free →