Working with Multiple Worksheets

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

Grouping and ungrouping worksheets

When worksheets are grouped, the information you enter into one worksheet is entered into all sheets in the group. Grouping worksheets saves you time; it eliminates all that cutting and pasting.

Important pointRemember to ungroup worksheets after you are finished entering, moving, or copying common data.

To ungroup worksheets:

  • Right-click any of the selected sheet tabs.
  • Choose Ungroup Sheets from the shortcut menu.

ungroup sheets image