See all How-To Articles

Select Multiple (or All) Sheets in Excel & Google Sheets

This tutorial demonstrates how to select multiple sheets in Excel and Google Sheets.

 

select all sheets initial data

 

Select All Sheets

In Excel, you can select all sheets in a workbook and apply changes to all of them at once. If you select every sheet and change the value in one cell on one sheet, the new value is automatically entered in all selected sheets. For example, say you have a workbook with six sheets.

 

select all sheets initial data

 

To select all sheets, right-click on any sheet’s tab (here, Sheet1), and choose Select All Sheets.

 

select all sheets 1

 

When sheets are selected, their color is changed to white, while unselected sheets have a gray background color.

 

select all sheets final data

 

Change Values in Selected Sheets

Now, to change the value of cell C36 in all sheets to 10, change the cell in any sheet in the workbook. Here, the value changed in Sheet1.

 

select all sheets change cell

 

Now, switching to any tab (e.g., Sheet3) shows that the value of C36 is set to 10 in all worksheets.

 

select all sheets change cell 2

 

Unselect All Sheets

To deselect all sheets, click on any of the selected tabs, and choose Ungroup Sheets.

 

unselect all sheets right click

 

Only the tab you right-clicked (here, Sheet1) is now selected.

 

unselect all sheets right click final

 

Select Multiple Sheets at Once

You can also select multiple sheets at once without selecting them all. Use the CTRL button on the keyboard for the selection. Press and hold CTRL, then click on each tab (sheet name) you want to select.

 

select multiple sheets at once

 

To select consecutive sheets (e.g., Sheet2, Sheet3, Sheet4, and Sheet5), you could also use the SHIFT button. Select the first tab (here, Sheet2), press and hold SHIFT, and click on the last tab you want to select (here, Sheet5).

 

select multiple consecutive sheets

 

Now worksheets Sheet2 through Sheet5 are selected.

Note: To select worksheets without having to click each one, you can use a macro to select by tab name, index number, or VBA code name.

Select Multiple Sheets in Google Sheets

Google Sheets doesn’t have the Select All Sheets option, but you can use CTRL or SHIFT to select multiple or all sheets.