Group Multiple Sheets

Excel Tips & Tricks

Group Multiple Sheets — Want to make changes to multiple sheets? Group sheets together, Ctrl-click the tabs of each sheet you want grouped together. They will turn white when grouped together, grey when not grouped. Everything done on one cell will be reflected on all sheets in the same cell. Make sure to ungroup sheets once completed to avoid accidentally inserting or removing data. To ungroup: click on one of the tabs. Possible usage:

1. Insert sheets in your group without adding and having to drag the sheet to desired location.

2. Delete a group of sheets not needed.

3. Move a group of sheets by right-click the group and Move/Copy to desired location.

4. Print quickly. Need to print multiple pages. Save time and group them together.

5. Enter same data to each grouped sheet, write formulas, apply formatting at one time.