Working with Multiple Worksheets

Use multiple worksheets in Excel when working with a large amount of data so it is better organized and easier to find content.

Grouping and ungrouping worksheets

You can work with each worksheet individually, or you can work with multiple worksheets at the same time. Worksheets can be combined together into a group. Any changes made to one worksheet in a group will be made to every worksheet in the group.

To group worksheets:

  1. Select the first worksheet you want to include in the worksheet group.
    selecting the first worksheet in a group
  2. Press and hold the Ctrl key on your keyboard. Select the next worksheet you want in the group.
    adding a worksheet to a group
  3. Continue to select worksheets until all of the worksheets you want to group are selected, then release the Ctrl key. The worksheets are now grouped.
    the grouped worksheets

While worksheets are grouped, you can navigate to any worksheet within the group. Any changes made to one worksheet will appear on every worksheet in the group. However, if you select a worksheet that is not in the group, all of your worksheets will become ungrouped.

To ungroup worksheets:

  1. Right-click a worksheet in the group, then select Ungroup Sheets from the worksheet menu.
    ungrouping worksheets
  2. The worksheets will be ungrouped. Alternatively, you can simply click any worksheet not included in the group to ungroup all worksheets.
    the ungrouped worksheets