How to use Sheets Manager
Start the add-on
Start your Sheets Manager from the Google Sheets menu: Extensions > Sheets Manager > Start.
Tip. The add-on is also part of the
Power Tools collection. For Power Tools, do the following:
- Go to Extensions > Power Tools > Start:
- Click the Sheets Manager icon on the Smart Toolbar:

or go to the Process group and you'll see Sheets Manager there:
The add-on sidebar will appear with a list of all sheets available in the current spreadsheet along with a toolbar full of different options.
How to select multiple sheets to manage them all at once
Though you can handle each sheet individually, there's an option to select multiple sheets and perform different actions with all of them at once.
You can select several sheets in two ways:
How to rename a sheet
- Hover your mouse over the sheet you want to rename and click the Rename icon with a pencil:
- Enter the new name and press Enter to save it:
How to quickly find certain sheets
If there are too many sheets in the file, you can quickly find the required one using the Search field:

Just start typing the name of the sheet and only matches will remain visible in the tree view:

Select any found sheet to quickly hop to it in the spreadsheet and/or to process it with the add-on.
Tip. When you use the Search, the sheet count at the bottom will show how many tabs have been found out of their total number:

As soon as you select any sheet in the add-on, the count will change to show how many exactly are selected:
How to reorder sheets within the file
To move the tab(s) closer to the beginning or to the end of the list, select the sheet(s) and drag & drop them to the required position:

Or right-click the selected sheet(s) and make use of 4 options from the context menu:

- Move up to move the sheets to the left.
- Move down to move the sheets to the right.
- Move to top will put the sheets first in the file.
- Move to bottom will put the sheets last in the file.
How to hide sheets in Google Sheets
There are 2 ways to hide the sheet(s) in Google Sheets:
- Select all sheets that you want to hide and press Hide on the toolbar:

or click on the down-arrow next to the option and choose Hide sheet(s) from there:
- Alternatively, right-click the selected Google sheet(s) and pick Hide from the context menu:

The font color of all hidden sheets will turn light gray:
Tip. You can view hidden sheets in the add-on list by opening the same drop-down and ticking off
Show hidden sheets accordingly:
Note. If you select both types of sheets — hidden and unhidden, the option will always offer to
Unhide them first. But you can always find both options —
Hide sheets and
Unhide sheets — by clicking the down-arrow:

and in the context menu:
How to unhide sheets in Google Sheets
There are 2 ways to unhide hidden sheet(s) in Google Sheets using our Sheets Manager.
Tip. Hidden sheets are written in a light gray font.
- Select all sheets that you want to unhide and choose the Unhide option on the toolbar:

or click on the down-arrow next to the option and select Unhide sheet(s) from there:
- Another way to unhide sheets in Google Sheets is to select them in the add-on tree view, right-click and pick Unhide from the context menu:
Note. If you select both types of sheets to handle — hidden and unhidden, the option will always offer to
Unhide them first. But you can always find both options —
Hide sheets and
Unhide sheets — by clicking the down-arrow:

and in the context menu:
How to color-code Google sheets
To color code any tab in the Google spreadsheet, select the sheet in the add-on tree view and click Change color:

You'll see a color palette offering to pick a color or reset any previously selected one:

How to lock Google sheets
You can protect (or lock) Google sheets in 2 ways:
- Select all sheets that you want to lock, click the Protect icon (the one with a padlock) and choose a way to limit the editing:
- Pick Restrict editing if you want to prevent other users from making any changes to the sheet.
- Or opt for Show warning if you don't really mind the changes but want other users to see a corresponding warning and confirm if they want to edit.
- You will also find the same options in the context menu if you right-click any of the selected sheets:
As soon as the sheets are protected, a padlock will appear next to their names:

How to unlock Google sheets or change editing permissions
- Select all protected sheets (those with a padlock next to them).
- Click the Protect icon (the one with a padlock as well) and either change a way to limit the editing or unlock the sheets completely:
- Restrict editing will prevent other users from making any changes to the sheets.
- Show warning will make other users confirm if they want to edit the sheet.
- Unprotect will remove any protection and let any user edit the sheets freely.
Tip. You will see the same options in the context menu if you right-click one of the selected sheets:
Note. The same options will also be available if you select both types of sheets in the tree view — protected and unprotected.
How to duplicate multiple Google sheets
- Select all sheets that you want to duplicate within the current spreadsheet.
- Click Copy to > Current spreadsheet:
All selected sheets will be duplicated and their copies will appear in your file and at the end of the add-on list.
How to copy Google sheets to another spreadsheet
- Select all sheets that you want to copy to another spreadsheet.
- Click Copy to and pick one of the options:
How to move Google sheets to another file
To move several Google sheets to another file entirely (cut from the current file and paste in another one), select the sheets of interest, click the Move to option, and pick a destination:

- The New spreadsheet option will create a brand new file in your Drive and transfer all selected sheets there. Once it happens, you will get a link to open that new spreadsheet:
- Existing spreadsheet will first let you select the desired spreadsheet from Drive:

Then it will move all selected sheets there.
Tip. Instead of browsing from folder to folder manually, make use of the
Search field. The add-on will show you all files with partial/complete name matches found in your personal Drive, all Shared Drives (if any), and spreadsheets that have been shared with you.
You will also have a link to access that file right away:
- Multiple new spreadsheets will move each selected sheet into a new file. The add-on will create a new folder next to your current file in Drive and put all these new spreadsheets there. You will also have a link to open that new folder named after your spreadsheet quickly:
How to delete Google sheets
To delete Google sheets from the file, select them in the add-on and click the corresponding icon on the add-on toolbar:

The sheets will be completely removed from both the spreadsheet and the add-on list.
How to check the number of all sheets in the file
There's a sheet count available in the footer of the add-on.
Most of the time, the number will show how many sheets you selected to handle:

To find out the total number of sheets in the spreadsheet, unselect all sheets:

Tip. When you use
the Search, the sheet count at the bottom will show how many tabs have been found out of their total number:

As soon as you select any sheet in the add-on, the count will change to show how many exactly are selected: