Multiple non contiguous sheets
To select multiple non contiguous sheets:
-
Click on the sheet tab for the first sheet.
-
Move the mouse pointer over the second sheet tab.
-
Hold down the Control key and click on the sheet tab.
-
Repeat as necessary.
The selected tabs will turn white. Any actions that you perform will now affect all highlighted sheets.