Using the Select Non-Adjacent Worksheet Shortcut
Windows keyboard shortcut
Mac keyboard shortcut
Use this Excel shortcut to select additional non-adjacent worksheets. When pressing down CTRL (Command on Mac) and click another worksheet, the active sheet and clicked sheet will be selected. You can select as many additional non-adjacent worksheets as needed.
Other useful Workbook keyboard shortcuts