How to Add a New Sheet (Tab) in Google Sheets

When you create a new document in Google Sheets, you are given a massive grid of rows and columns. However, packing all your data onto a single grid can quickly become chaotic. A much better way to organize complex data—like keeping January’s budget separate from February’s, or keeping employee rosters separate from inventory lists—is to use multiple sheets (often called tabs) within the same file. Adding new tabs keeps your data cleanly segmented while ensuring everything stays inside one easily shareable document.

How to Add a New Sheet

Adding a new blank tab takes only a single click.

1. Open your Google Sheets document.
2. Look at the very bottom left corner of your screen, below the main spreadsheet grid. You will see a tab labeled “Sheet1” (this is the grid you are currently looking at).
3. To the left of “Sheet1”, click the Plus (+) button.
4. A new, completely blank grid will instantly appear, and a new tab labeled “Sheet2” will be added to the bottom row.
5. You can click back and forth between “Sheet1” and “Sheet2” to switch between the different grids.

How to Rename Your New Sheet

Having tabs named “Sheet1”, “Sheet2”, and “Sheet3” isn’t very helpful. You should rename them immediately so you know what data they contain.

1. Locate the tab you just created at the bottom of the screen (e.g., “Sheet2”).
2. Double-click directly on the word “Sheet2”. The text will become highlighted in blue.
3. Type a new, descriptive name (e.g., “Q3 Expenses”).
4. Press the Enter key on your keyboard to save the name.

Alternatively, you can click the small downward-facing arrow next to the tab name and select Rename from the menu.

How to Duplicate an Existing Sheet

Sometimes you don’t want a blank grid. If you have spent an hour formatting a beautiful monthly report on Sheet1, you don’t want to recreate that formatting from scratch for Sheet2. You can simply duplicate it.

1. Locate the tab you want to copy at the bottom of the screen.
2. Click the small downward-facing arrow next to the tab’s name.
3. From the menu that pops up, select Duplicate.
4. An exact copy of the sheet—including all data, formatting, formulas, and colors—will appear next to it, labeled as “Copy of [Your Sheet Name]”. You can now rename it and clear the old data while keeping the formatting intact.

How to Rearrange Your Sheets

If you add tabs out of chronological order, you can easily reorganize them.

1. Click and hold your left mouse button on the tab you want to move.
2. Drag the tab to the left or right along the bottom bar.
3. Release the mouse button to drop the tab into its new position.