To select one sheet
- Click the worksheet tab
To select more than one sheet
- Use CTRL+click and SHIFT+click to select multiple sheets, or right-click a tab and choose Select All for all sheets. This is referred to as grouping worksheets. Each action you perform will apply to all selected sheets.
To ungroup sheets
- Click any one sheet (tab) or right-click a sheet and choose Ungroup Sheets.