How To Select Multiple Tabs In Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to select multiple tabs in Google Sheets.

There are a number of operations that can be performed on tabs in Google Sheets. For example, you can duplicate a sheet, change the tab color, or hide the tab to name a few. Each of these operations can be performed in just a few clicks, but what if you have a large number of tabs to apply the operation to? It would be slow and tedious to manually repeat the same sequence of clicks for each tab you want to hide, or move or delete, but fortunately there’s a faster way. By selecting multiple Google Sheets tabs, you can apply the same operation to all the tabs at once and save time

Here’s how:

Step 1

Select the first sheet by clicking on the tab with the sheet’s name on it at the bottom of the screen. If you can’t see the sheet, use the right and left arrows to the right of the sheet tabs to navigate through the sheets

Step 2

To select adjacent sheets, hold down the shift key and then click on the last sheet you want to select. All sheets between the two selected sheets will be selected. Selected sheets will be highlighted white instead of grey

Step 3

You can select non-adjacent sheets by holding down control instead of shift and individually clicking on each sheet you want to select

Step 4

Once you’ve selected the tabs you want, right click on one of the selected tabs and choose the operation you want to perform on the selected tabs from the menu