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.
Related videos
The videos below demonstrate this shortcut.
In this lesson, we cover shortcuts you can use to navigate workbooks.
In this video, we show you how to move and copy worksheets in the between different workbooks.
In this video, we show you how to insert new worksheets to a workbook, and how to remove existing worksheets from a workbook.
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.
