If you want to select adjacent sheets then you can do that by holding down the shift key and clicking on the next sheet tab.For e.g. There are six worksheets - sheet 1 to sheet 6. And you want to select one to four then simply select the first sheet, hold down the shift key and click on the forth sheet.You will notice this will automatically select sheet 2 and 3 as well.
However if you want to select non adjacent sheets then hold down both the shift and control keys together and choose the desired sheet.

If you want to do a mouseless selection, just hold down the shift and control keys and press “Page up” or “page down”.

If you want to select all the worksheets at once then you can also right click on one of the sheet tab and choose “Select all sheets” option.

Popularity: 4%