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

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on April 30, 2022

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.

AI Formula Generator

Try for Free

See all How-To Articles