Exceljet

Quick, clean, and to the point

Select non-adjacent worksheets

Windows shortcut 
CtrlClick
Mac shortcut 
⌘Click

Use this keyboard shortcut to select additional non-adjacent worksheets. When you hold the Control key down (Command on the Mac), and click another worksheet tab the active worksheet and clicked worksheet will be selected. You can select as many additional worksheets as you like.

See all shortcuts

Related videos

The videos below demonstrate this shortcut.
How to insert and delete worksheets
In this video we show you how to insert new worksheets to a workbook, and how to remove existing worksheets from a workbook.
How to use the CHOOSE function
In this video we'll look at how you can use the CHOOSE function. We also compare a formula based on CHOOSE vs. a formula based on VLOOKUP.
How to move and copy worksheets to other workbooks
In this video we show you how to move and copy worksheets to other workbooks.
Shortcuts to navigate workbooks
In this lesson, we cover shortcuts you can use to navigate workbooks.

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.