Now you can select multiple tabs in Google Sheets and perform basic actions on the selection (such as moving the tabs together, deleting, duplicating, copying, coloring, or hiding). Work in Google Sheets with confidence and make workflows faster as you perform basic actions on more than one sheet at a time.
To select multiple tabs, press "Ctrl" to select individual tabs, "Shift" to select contiguous tabs.
Getting started
- Admins: There is no admin control for this feature.
- End users: This feature will be ON by default. Visit the Help Center to learn more about how to protect, hide, and edit sheets.
Rollout pace
- Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on July 21, 2021
Availability
- Essentials, Business Starter, Business Standard, Business Plus, Frontline, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Plus, Nonprofits, Cloud Identity Free, Cloud Identity Premium. Also available to users with personal Google Accounts.
Resources
- Google Help: Protect, hide, and edit sheets
Do you have tabs in your Google spreadsheet that you want to hide so that they no longer show at the bottom, but are still available to view / unhide later? Or perhaps you have hidden tabs and you want to know how to unhide them again. In this lesson I am going to show you how to hide and unhide tabs in Google Sheets.
To hide a tab in Google Sheets, follow these steps:
- Right-click near the tab name, or click the small triangle near the tab name
- Click "Hide sheet"
Note that you cannot hide a sheet if it is the only tab in the file.
To unhide a tab in Google Sheets, follow these steps:
- On the top toolbar menu, click "View"
- Hover your cursor over "Hidden sheets"
- Click on the sheet that you want to unhide
Google Sheets will show in the menu how many sheets are hidden. If no sheets are hidden, you will not be able to expand the "Hidden sheets" menu.
After hiding the tab it will no longer display in the list of tabs at the bottom of the sheet, and after unhiding the tab it will display in the list of tabs at the bottom again.
Below are detailed examples showing how to hide and unhide tabs in Google Sheets.
How to hide a tab in Google Sheets
Hiding tabs can be useful for many reasons. You can duplicate tabs and then hide them as backups, or you can simply hide tabs that you don't want others to see. When I create dashboards in Google Sheets, I like to hide the "back end" tabs that contain formulas / raw data that others might not need to view. Hiding tabs will keep important tabs in the file, but will keep the sheet clean when others use it.
Let's use a simple dashboard as an example. In the example below, there are two tabs present in the Google Sheets file. One is a tab named "Import", which contains raw data, and another tab is named "Dashboard", which contains data visualizations. Let's say that we want to hide the "Import" tab so that people can only see the "Dashboard" tab.
(The "Dashboard" tab is connected to the "Import" tab via formulas / references, and hiding the "Import" tab will not affect these connections. In other words, we can hide the raw data and the visualizations will still function properly.)
Follow the instructions below to see how to hide the "Import" tab.
To hide a tab, simply right-click on the tab that you want to hide (Or you can click the small triangle that points downwards, on the right side of the tab name), and then click "Hide sheet".
After following the instructions above to unhide a tab, the tab will be visible again at the bottom of the sheet, as shown below.
A Google spreadsheet can contain one or more sheets. When working with a large amount of information, you can create multiple sheets to help organize your spreadsheet and make it easier to find information.
In this lesson, you'll learn how to create, rename, move, delete, and duplicate sheets.
Using multiple sheets
When you create a new Google spreadsheet, it has one sheet, which is named Sheet1 by default. In the sheets toolbar located at the bottom of the window, you will see a tab for each sheet you have. To organize your spreadsheet and make it easier to navigate, you can create, rename, delete, move, and duplicate sheets.
Watch the video below to learn how to create and manage multiple sheets.
To create a new sheet:
In our example, the sheets of our service log are organized by month. We'll create a new sheet in the log so data can be entered in the new month.
- Click the Add Sheet command in the sheets toolbar.
- A new sheet will appear in the sheets toolbar.
Alternatively, you can create an additional sheet by clicking Insert and selecting New sheet from the drop-down menu.
To rename a sheet:
- Click the tab of the sheet you want to rename. Select Rename... from the menu that appears.
- Type the desired name for the sheet.
- Click anywhere outside of the tab or press Enter on your keyboard when you're finished, and the sheet will be renamed.
To switch to a different sheet:
- Click the desired sheet tab in the sheets toolbar.
- The selected sheet will appear.
If you want to limit collaborators from editing specific sheets of your spreadsheet, you can protect these sheets by clicking the desired sheet tab and selecting Protect sheet... from the menu that appears.
To move a sheet:
- Click and drag the tab of the sheet you want to move.
- Release the mouse to place the tab at the desired location.
To duplicate a sheet:
- Click the tab of the sheet you want to duplicate, then select Duplicate from the menu that appears.
- A duplicate of the sheet will appear in the sheets toolbar. It will be named as a copy of the original sheet, such as Copy of May. If you want, you can rename the sheet.
To copy a sheet to another spreadsheet in Google Drive, click the tab of the sheet you want to copy, then select Copy to... from the menu that appears. Select the spreadsheet where you want to place the copy from the list that appears. A duplicate of the sheet will appear in the other spreadsheet.