 |
 |
|
|
|
Grouping Worksheets Grouping worksheets enables you to format all sheets in the group to look the same, to enter formulas on one sheet and have the formulas actually be entered on all sheets at once, or create range names for each sheet in the group. When sheets are grouped, any changes made to one sheet take effect on all other sheets as well. Before grouping sheets, first make sure you have one extra sheet to the right of the sheets you want grouped. If you don't, your sheets won't stay grouped after you group them. Then to group the sheets, select the first sheet to be in the group, then hold down the Shift key and select the last sheet to be in the group. If you'd like to select sheets that are not adjacent to each other, click on each sheet to be included in the group while holding down the CTRL key. After you group the sheets, notice that [Group] appears in the title bar and each of the sheet tabs in the group is white. As long as you don't click on the sheet tab of a worksheet that is not in the group, the sheets will stay grouped. To ungroup the sheets, simple click on any sheet tab that is not a part of the group (not white). While the sheets are grouped, any data
or formula you enter on one sheet is also being entered in the same cell
in every sheet in the group. Any formatting change you make is also
being made to the same cells in every sheet in the group.
|
