Working with Worksheets

When working in Excel group worksheets and freeze certain cells to more effectively navigate worksheets.

Grouping and ungrouping worksheets

A workbook is a multi-page Excel document that contains multiple worksheets. Sometimes you will want to work with the worksheets one at a time as if each is a single unit. Other times, the same information or formatting may need to be added to every worksheet.

Worksheets can be combined together into a group. Grouping worksheets allows you to apply identical formulas and/or formatting across all of the worksheets in the group. When you group worksheets, any changes made to one worksheet will be changed in any other worksheets in the group.

To group contiguous worksheets:

Grouped Worksheets

To group noncontiguous sheets:

To ungroup worksheets: