How to insert, delete, rename, and reorder tabs in Google Sheets

Spreadsheet Class · Intermediate ·📊 Data Analytics & Business Intelligence ·4y ago

Key Takeaways

This video demonstrates how to manage tabs in Google Sheets, including adding, deleting, renaming, and reordering them. It covers two methods for adding new sheets, deleting tabs, renaming tabs, and reorganizing their order.

Full Transcript

in this video i'm going to show you how to do a variety of things with tabs in google sheets i'm going to show you how to add a new sheet how to delete sheets how to rename sheets and also how to reorder them so these are all very simple things and so this will be a quick video as you can see i already have a tab that's named line chart in my spreadsheet and let's say that i wanted to add a new tab to my google sheets workbook so there's two different ways that i can do this first hover your cursor over the plus sign at the bottom left where it says add sheet if you click this google sheets will automatically add a new tab a new blank tab now another way that you can add a new sheet is to click insert on the top toolbar menu scroll down and click new sheet and as you can see google sheets has added another new blank tab now if you're adding new tabs sometimes you'll of course want to delete them and you can do this by right-clicking on the tab that you want to delete or you can simply click the small triangle near the tab name and then click delete and then click ok so as you can see the tab that i just created has now been deleted now when you're creating new tabs you'll also want to be able to rename these tabs so that other people can see what it is that the tab represents and so to rename a tab simply double click on the tab name and rename your tab so i'm going to type notes 1 and then press enter so now i've renamed my tab notes 1 and others can now see that this tab is designated for taking notes now if you want instead of double clicking you can right click or click that small triangle and then click rename and this does the same as double clicking on the tab name so now that you know how to add delete and rename tabs you might also want to know how to reorganize them or how to reorder them to do this simply click on a tab name and hold your click and then drag your cursor to the left or to the right now as you can see i've moved the notes one tab from the right to the left and now these tabs are in different orders so i hope you liked this video if you did please like and subscribe and if you want to read the article version of this video i've linked the article below

Original Description

Get help with your spreadsheet project, or personalized training: https://www.spreadsheetclass.com/consulting/ Get the ultimate formulas cheat sheet https://www.spreadsheetclass.com/best-google-sheets-cheat-sheet/ Learn to build dashboards in Google Sheets: https://www.spreadsheetclass.com/google-sheets-dashboards-course/ In this video I teach you how to insert tabs (add new sheets), delete tabs, rename tabs, and reorder tabs (organize tabs) in Google Sheets. Article: https://www.spreadsheetclass.com/insert-delete-rename-organize-tabs-in-google-sheets/
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from Spreadsheet Class · Spreadsheet Class · 39 of 60

1 How to use the FILTER function in Google Sheets (Single or Multiple Conditions)
How to use the FILTER function in Google Sheets (Single or Multiple Conditions)
Spreadsheet Class
2 5 formulas that combine columns in Google Sheets (Horizontal and Vertical)
5 formulas that combine columns in Google Sheets (Horizontal and Vertical)
Spreadsheet Class
3 All the ways to extract text and numbers in Google Sheets
All the ways to extract text and numbers in Google Sheets
Spreadsheet Class
4 How to filter based on a list in Google Sheets
How to filter based on a list in Google Sheets
Spreadsheet Class
5 How to fix the "FILTER has mismatched range sizes" error in Google Sheets
How to fix the "FILTER has mismatched range sizes" error in Google Sheets
Spreadsheet Class
6 How to color cells, and alternate row colors in Google Sheets
How to color cells, and alternate row colors in Google Sheets
Spreadsheet Class
7 How to automatically create a series of values in Google Sheets
How to automatically create a series of values in Google Sheets
Spreadsheet Class
8 Google Sheets Beginner Tutorial
Google Sheets Beginner Tutorial
Spreadsheet Class
9 How to make a Dashboard in Google Sheets (Full Tutorial)
How to make a Dashboard in Google Sheets (Full Tutorial)
Spreadsheet Class
10 Using the SORT and FILTER function in the same formula in Google Sheets
Using the SORT and FILTER function in the same formula in Google Sheets
Spreadsheet Class
11 ARRAYFORMULA function: Apply a formula to an entire column in Google Sheets
ARRAYFORMULA function: Apply a formula to an entire column in Google Sheets
Spreadsheet Class
12 Automatically resize columns in Google Sheets with Fit to Data
Automatically resize columns in Google Sheets with Fit to Data
Spreadsheet Class
13 How to import or convert a CSV file into Google Sheets
How to import or convert a CSV file into Google Sheets
Spreadsheet Class
14 How to export / download a CSV from Google Sheets
How to export / download a CSV from Google Sheets
Spreadsheet Class
15 How to change text case in Google Sheets  with UPPER LOWER and PROPER
How to change text case in Google Sheets with UPPER LOWER and PROPER
Spreadsheet Class
16 How to use the Calendar Template in Google Sheets
How to use the Calendar Template in Google Sheets
Spreadsheet Class
17 How to rotate text in Google Sheets
How to rotate text in Google Sheets
Spreadsheet Class
18 How to create charts in Google Sheets (And how to customize them too)
How to create charts in Google Sheets (And how to customize them too)
Spreadsheet Class
19 How to copy formulas, and lock cell references in Google Sheets (Relative & absolute references)
How to copy formulas, and lock cell references in Google Sheets (Relative & absolute references)
Spreadsheet Class
20 How to copy and paste values only in Google Sheets
How to copy and paste values only in Google Sheets
Spreadsheet Class
21 How to fix the "Circular Dependency Detected" error in Google Sheets
How to fix the "Circular Dependency Detected" error in Google Sheets
Spreadsheet Class
22 Evenly space columns in Google Sheets (Make columns the same size quickly)
Evenly space columns in Google Sheets (Make columns the same size quickly)
Spreadsheet Class
23 Doing math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square, Square Root
Doing math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square, Square Root
Spreadsheet Class
24 How to filter horizontally in Google Sheets (Filter columns)
How to filter horizontally in Google Sheets (Filter columns)
Spreadsheet Class
25 UNIQUE function: Removing duplicates with 2 methods in Google Sheets
UNIQUE function: Removing duplicates with 2 methods in Google Sheets
Spreadsheet Class
26 Report Builder template for Google Sheets (Automatically organize / calculate your data)
Report Builder template for Google Sheets (Automatically organize / calculate your data)
Spreadsheet Class
27 Build a Google Sheets dashboard with Google Forms data (Automated)
Build a Google Sheets dashboard with Google Forms data (Automated)
Spreadsheet Class
28 Guitar tabs template for Google Sheets (& PDF) | Create your songs in a Google spreadsheet
Guitar tabs template for Google Sheets (& PDF) | Create your songs in a Google spreadsheet
Spreadsheet Class
29 Interactive Google Sheets dashboard with drop down menus tutorial
Interactive Google Sheets dashboard with drop down menus tutorial
Spreadsheet Class
30 Student attendance dashboard tutorial in Google Sheets: Simple + advanced
Student attendance dashboard tutorial in Google Sheets: Simple + advanced
Spreadsheet Class
31 SORT function in Google Sheets (Sort data vertically or horizontally)
SORT function in Google Sheets (Sort data vertically or horizontally)
Spreadsheet Class
32 How to use the SORT function in Google Sheets (Quick Version)
How to use the SORT function in Google Sheets (Quick Version)
Spreadsheet Class
33 How to copy chart formatting and duplicate charts in Google Sheets
How to copy chart formatting and duplicate charts in Google Sheets
Spreadsheet Class
34 How to copy a tab to a new file / sheet in Google Sheets
How to copy a tab to a new file / sheet in Google Sheets
Spreadsheet Class
35 How to duplicate tabs in Google Sheets
How to duplicate tabs in Google Sheets
Spreadsheet Class
36 How to hide and unhide tabs in Google Sheets
How to hide and unhide tabs in Google Sheets
Spreadsheet Class
37 How to make a copy of a file in Google Sheets
How to make a copy of a file in Google Sheets
Spreadsheet Class
38 How to change tab color in Google Sheets
How to change tab color in Google Sheets
Spreadsheet Class
How to insert, delete, rename, and reorder tabs in Google Sheets
How to insert, delete, rename, and reorder tabs in Google Sheets
Spreadsheet Class
40 How to move a chart to another sheet in Google Sheets
How to move a chart to another sheet in Google Sheets
Spreadsheet Class
41 How to wrap text, unwrap text, and clip text in Google Sheets
How to wrap text, unwrap text, and clip text in Google Sheets
Spreadsheet Class
42 Switch columns and rows with the TRANSPOSE function in Google Sheets
Switch columns and rows with the TRANSPOSE function in Google Sheets
Spreadsheet Class
43 Project management timeline template for Google Sheets (Gantt Chart)
Project management timeline template for Google Sheets (Gantt Chart)
Spreadsheet Class
44 Build a dashboard in 3 simple steps (Google Sheets)
Build a dashboard in 3 simple steps (Google Sheets)
Spreadsheet Class
45 Pull data from websites in Google Sheets with IMPORTXML function | Web scraping (Stock prices)
Pull data from websites in Google Sheets with IMPORTXML function | Web scraping (Stock prices)
Spreadsheet Class
46 (Quick version) Pulling data from websites with IMPORTXML function | Google Sheets web scraping
(Quick version) Pulling data from websites with IMPORTXML function | Google Sheets web scraping
Spreadsheet Class
47 Pull cryptocurrency prices in Google Sheets (2 methods) | GOOGLEFINANCE and IMPORTXML crypto prices
Pull cryptocurrency prices in Google Sheets (2 methods) | GOOGLEFINANCE and IMPORTXML crypto prices
Spreadsheet Class
48 Fast & simple dashboard tutorial for Google Sheets (Build in under 15 minutes)
Fast & simple dashboard tutorial for Google Sheets (Build in under 15 minutes)
Spreadsheet Class
49 How to create drop-down lists in Google Sheets (Data validation)
How to create drop-down lists in Google Sheets (Data validation)
Spreadsheet Class
50 The ultimate cheat sheet for Google Sheets (Formulas, charts, shortcuts, and more)
The ultimate cheat sheet for Google Sheets (Formulas, charts, shortcuts, and more)
Spreadsheet Class
51 3 ways to pull crypto prices into Google Sheets | GOOGLEFINANCE, IMPORTXML, IMPORTDATA
3 ways to pull crypto prices into Google Sheets | GOOGLEFINANCE, IMPORTXML, IMPORTDATA
Spreadsheet Class
52 Stock & crypto tracker templates for Google Sheets (Portfolio, Analysis, Watchlist, Screener)
Stock & crypto tracker templates for Google Sheets (Portfolio, Analysis, Watchlist, Screener)
Spreadsheet Class
53 How to indent in Google Sheets (5 Methods)
How to indent in Google Sheets (5 Methods)
Spreadsheet Class
54 Pull stock prices & stock data with the GOOGLEFINANCE function in Google Sheets (& Crypto too)
Pull stock prices & stock data with the GOOGLEFINANCE function in Google Sheets (& Crypto too)
Spreadsheet Class
55 How to create and customize charts in Google Sheets (Quick version)
How to create and customize charts in Google Sheets (Quick version)
Spreadsheet Class
56 Apply a formula to an entire column in Google Sheets with the ARRAYFORMULA function | Quick Version
Apply a formula to an entire column in Google Sheets with the ARRAYFORMULA function | Quick Version
Spreadsheet Class
57 How to insert a new line in a cell (or formula) in Google Sheets
How to insert a new line in a cell (or formula) in Google Sheets
Spreadsheet Class
58 How to freeze rows & columns (& How to unfreeze) in Google Sheets
How to freeze rows & columns (& How to unfreeze) in Google Sheets
Spreadsheet Class
59 How to add and sum in Google Sheets (Addition and SUM function)
How to add and sum in Google Sheets (Addition and SUM function)
Spreadsheet Class
60 How to average in Google Sheets (Using the AVERAGE function)
How to average in Google Sheets (Using the AVERAGE function)
Spreadsheet Class

This video teaches how to add, delete, rename, and reorder tabs in Google Sheets, which is essential for organizing and managing spreadsheet data. By mastering these skills, users can work more efficiently in Google Sheets.

Key Takeaways
  1. Hover over the plus sign at the bottom left and click to add a new sheet
  2. Click Insert on the top toolbar menu and select New sheet to add a new tab
  3. Right-click on a tab and select Delete to delete a tab
  4. Double click on a tab name to rename it
  5. Click on a tab name, hold, and drag to the left or right to reorder tabs
💡 There are multiple ways to add new sheets in Google Sheets, including using the plus sign at the bottom left and the Insert menu.

Related AI Lessons

Before I needed it, no one told me that "legacy tape management" was an entire industry.
Learn about legacy tape management and its importance in data migration, especially when dealing with large-scale tape collections
Reddit r/artificial
Top 5 DBMS Concepts (2026) | Perfectnotes
Learn the top 5 DBMS concepts to manage data efficiently in applications
Medium · Data Science
The Nervous System of the Telco: Unlocking the Real-Time Power of the Network Element Interfaces…
Unlock the power of network element interfaces to enable real-time insights in telco operations
Medium · Data Science
Enhanced RFM Analysis for Customer Segmentation using K-Prototypes
Learn how to enhance RFM analysis for customer segmentation using K-Prototypes, a clustering algorithm that handles categorical and numerical data, to improve marketing strategies and customer targeting.
Medium · Machine Learning
Up next
Spreadsheet Guy Meets the CFO: "Define How Much"
Digital Transformation with Eric Kimberling
Watch →