Group Worksheets

 

You can group worksheets if you want to edit multiple worksheets at the same time. Our workbook contains 3 similar worksheets (North, Mid and South) and a blank fourth worksheet.

1. To group worksheets, hold down CTRL and click the sheet tabs of the sheets you want to group.

Group Worksheets in Excel

Advertisement

2. Release CTRL.

Now you can edit multiple worksheets at the same time.

3. For example, on the North sheet, change the value of cell B2 to $1000 and delete row 4.

North

4. Go to the other two worksheets and you'll see that these worksheets have been edited as well.

Mid

South

5. To ungroup, right click one of the sheet tabs and click Ungroup Sheets or click any sheet tab outside the group. For example, the sheet tab of Sheet4.

Advertisement

Like this free tutorial? Please share, pin, tweet or +1 this page.

Go back to worksheets, Go to the right >>
Go to Top: Group Worksheets    |    Go to Next Example: Consolidate