Select Adjacent Sheets in Excel
Selecting adjacent worksheets allows you to apply the same formatting, data entry, or edits across multiple continuous sheets at the same time.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Shift + Click sheet tabs | Shift + Click sheet tabs |
What Does This Shortcut Do?
This method selects all worksheets between the first and last selected sheet, creating a grouped selection.
How to Use the Shortcut
- Click the first worksheet tab
- Hold Shift
- Click the last worksheet tab in the range
- All sheets between them will be selected
Tips & Best Practices
- Grouped sheets show [Group] in the Excel title bar
- Be careful when editing grouped sheets — changes apply to all
- Use Select Non-Adjacent Sheets for individual selections
FAQ
- Q: How do I ungroup selected sheets?
- Click any single sheet tab outside the group.
- Q: Can I print multiple adjacent sheets together?
- Yes, grouped sheets print as a single print job.
- Q: Does this work in all Excel versions?
- Yes, sheet grouping works in all modern Excel versions.