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.
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:
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:
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.
Alternatively, you can create an additional sheet by clicking Insert and selecting New sheet from the drop-down menu.
To rename a sheet:
To switch to a different sheet:
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:
To duplicate a 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.
How do I show all tabs in Google Sheets?
There are two quick ways to unhide tabs in Google Sheets..
Go to your Google Sheets and click "View". ... .
Place your mouse cursor over "Hidden sheets" to access the list of hidden tabs..
Why can't I see the sheet tabs in Google Sheets?
Display issues where parts of the interface are missing are usually due to zooming or window placement. Use Ctrl+0 (zero) to reset zooming to 100%. Adjust the window size to see all 4 corners of the browser window are less than the screen size.
How do I view multiple tabs in Google Sheets?
View Two Sheets at Once in Google Sheets.
To view two sheets from the same workbook in Google Sheets, open another copy of the browser you're working in..
Reopen the spreadsheet in that browser..
To show both browser windows at the same time, right-click on the Task Bar and select Show Windows side by side..
How do I show hidden tabs in Google Sheets?
To unhide a sheet:.
Click View Show [name]. If your spreadsheet doesn't have any hidden sheets, this option will be grayed out..
Click the sheet that you no longer want hidden..
The spreadsheet will reappear..