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

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:

In our example, employees need to receive training every three months, so we'll create a worksheet group for those employees. When we add the names of the employees to one worksheet, they'll be added to the other worksheets in the group as well.

  1. Select the first worksheet you want to include in the worksheet group.
    Screenshot of Excel 2013Selecting the first worksheet of the 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.
    Screenshot of Excel 2013Adding worksheets to the group
  4. Release the Ctrl key. The worksheets are now grouped.

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 all worksheets:

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