Select Non-Adjacent Sheets in Excel
Selecting non-adjacent worksheets allows you to apply changes to specific sheets without grouping all sheets between them.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + Click sheet tabs | Cmd + Click sheet tabs |
What Does This Shortcut Do?
This shortcut lets you select individual worksheet tabs that are not next to each other, creating a custom group.
How to Use the Shortcut
- Click the first worksheet tab
- Hold Ctrl (Windows) or Cmd (Mac)
- Click additional sheet tabs you want to select
- Release the key after selection
Tips & Best Practices
- Grouped sheets display [Group] in the title bar
- Ungroup by clicking any unselected sheet
- Use with caution — edits apply to all selected sheets
FAQ
- Q: Can I select both adjacent and non-adjacent sheets together?
- Yes, use a combination of Shift and Ctrl/Cmd clicks.
- Q: Will formulas update across all selected sheets?
- Yes, any edits affect all grouped sheets.
- Q: Is this selection temporary?
- Yes, the group exists until you ungroup the sheets.