One or multiple sheets can be selected using a mouse. It can be advantageous to select multiple sheets at times when you want to make changes to many sheets at a time
Click on the sheet tab for the sheet you want to select. The active sheet becomes white and any actions that you perform will now affect the selected cells in the sheet.
If you want unselect the selection, click on any unselected sheet
The following steps should be followed to select multiple continuous sheets.
• Click on the sheet tab for the first desired sheet.
• Hold down the Shift key and click on the last sheet tab.
All the tabs between these two sheets will be selected and turn white. Any actions that you perform will now affect all highlighted sheets. For example, if you want to select from sheet1 to sheet5. Do the following,
Step 1: Click on Sheet1 to select first sheet
Step 2: Press and held down “Shift” key and Click on the Sheet 5 i.e., last sheet
All the sheets between Sheet1 and Sheet5 will be selected and their sheet colour turns to white as given in the Figure X.X and any actions that you perform will now affect all highlighted sheets.
If you want to unselect the selection, click on any unselected sheet.
If you want to select multiple non-continuous sheets the following steps will be followed.
• Click on any sheet,
• Hold down the Ctrl key,
• Click another sheet.
Ctrl + Click on any sheet is used to select multiple sheets. Selected sheets tab colour turns into “White”.
For example, if you want to select Sheet1, Sheet3 and Sheet 7;
Step 1: Click on Sheet1 and then
Step 2: Hold down the Ctrl key
Step 3: Click on Sheet3 and then Sheet 7.
Selected Sheets colour becomes “White” and any actions that you perform will now affect all Selected sheets.