Excel is a powerful tool for organizing and analyzing data. One of the common tasks you may encounter is selecting multiple worksheets in a workbook. While you can do this manually by holding down the Ctrl key and clicking on each worksheet tab, it can be a time-consuming process if you have many worksheets. That’s where the Excel keyboard shortcut for selecting non-adjacent worksheets comes in handy.
Keyboard Shortcut to Select Non-adjacent Worksheets In Excel
The keyboard shortcut to select non-adjacent worksheets in Excel is Ctrl + Click for Windows and ⌘ + Click for Mac.
Here’s how to use it:
- Open the Excel workbook that contains the worksheets you want to select.
- Hold down the Ctrl key (Windows) or the ⌘ key (Mac).
- Click on the first worksheet tab you want to select.
- Continue holding down the Ctrl or ⌘ key and click on each additional worksheet tab you want to select.
- Release the Ctrl or ⌘ key once you have selected all the desired worksheets.
Points to Remember:
- The selected worksheets will be highlighted in white.
- You can also use this shortcut to deselect worksheets that are already selected.
- To select adjacent worksheets, simply click on the first worksheet tab, hold down the Shift key, and click on the last worksheet tab you want to select.
- You can also use the keyboard shortcuts Ctrl+Page Up and Ctrl+Page Down (Windows) or ⌘+{ and ⌘+} (Mac) to navigate between worksheets in a workbook.
In conclusion, knowing keyboard shortcuts like this one can help you work more efficiently in Excel. The CtrlClick (Windows) or ⌘Click (Mac) shortcut for selecting non-adjacent worksheets is a great time-saver, and once you’ve gotten the hang of it, you’ll wonder how you ever worked without it!