Worksheet Basics

In Excel basics are essential to better understand this spreadsheet program. Use this worksheet basics lesson for Excel help.

Grouping and ungrouping worksheets

Video: Grouping Worksheets in Excel 2010

Launch video!Watch the video (1:37).

You can work with each worksheet in a workbook individually, or you can work with multiple worksheets at the same time. Worksheets can be combined 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 in the group.
    Selecting the first worksheet to group Selecting the first worksheet to group
  2. Press and hold the Ctrl key on your keyboard.
  3. Select the next worksheet you want in the group. Continue to select worksheets until all of the worksheets you want to group are selected.
    Selecting the first worksheet to group Selecting additional worksheets to group
  4. Release the Ctrl key. The worksheets are now grouped. The worksheet tabs appear white for grouped worksheets.

While worksheets are grouped, you can navigate to any worksheet in the group and make changes that will appear on every worksheet in the group. If you click a worksheet tab that's not in the group, however, all of your worksheets will become ungrouped. You will have to group them again.

To ungroup all worksheets:

  1. Right-click one of the worksheets. The worksheet menu appears.
  2. Select Ungroup. The worksheets will be ungrouped.