Grouping Worksheets in MS Excel

I am not able to imagine the why one would want to group or ungroup worksheets in an Excel Workbook. Also have not tested this on Office 2003 platform so do not know the applicability there as of now.

Grouping Worksheet together.

One can group multiple sheets in MS Excel by selecting one or more sheet together.

• To select a single worksheet simply click on the worksheet.
• To select multiple adjacent sheets click on the first worksheet; Press and Hold the [Shift] key and then click the last worksheet. This will group all the worksheets together. You might have to use Tab Scrolling Buttons to navigate through worksheets tabs.
• To select multiple non-adjacent worksheets; press and hold [Ctrl] key and click one or more non-adjacent worksheets.

Note: When you select two or more adjacent or non-adjacent worksheets together they are grouped by Excel. The status of grouped sheets are appears as [Group] in the title bar of the open worksheet.

Impact of Grouping Sheets

Grouping worksheets together changes the way excel treats grouped worksheets when editing, printing or other such operations.

• Data being entered or edited in the active worksheet in group is reflected in all selected sheets.
  Note: The changes in active worksheet in the group apply to all worksheets that constitute the group. Hence editing a cell would replace data on the active sheet and on other sheets in group.
• Data that you copy or cut in grouped sheets cannot be pasted on another sheet, because the size of the copy area includes all layers of the selected group and is therefore different from the paste area in a single sheet outside the group.
  Note: Make sure that only one sheet is selected before you copy or move data to another worksheet.

Ungrouping the Worksheets

To ungroup the selected worksheets right click on one of the sheet in the group and then click Ungroup Sheets in the context sensitive menu.

I hope you found the information useful and Thank you for reading.