Grouping Sheets
When more than one sheet is
selected, the sheets are considered grouped. This means if
formatting, editing or data entry is completed on one sheet in the
group; all sheets will have the duplicate revisions/entries. Sheets
outside of the group will not be affected.
Setting up a Group:
select required sheets and make revisions (see below for info on how to
select select sheets).
When sheets are grouped the word
[Group] is displayed after the file
name in the Title Bar of the workbook.
Sheet Tabs in a group are
white versus gray. In sample below Sheet 1, Sheet 2, Sheet 4 and Sheet 6
are in a group.
Ungroup
sheets: Right-mouse click on a sheet tab and left-click
Ungroup Sheets or click a Sheet outside of the group.
Do not forget to
Ungroup sheets. Remember, actions performed in one sheet in a group
effects all sheets. Ungrouping sheets allows for all sheets to act
independently.
For more using grouping to copy Page Setups refer
to article on
Copying Page Setups.
Non-contiguous sheets: Click the first
sheet tab, hold down the Ctrl key and then click each sheet tab to be
selected.
Release Shift
or
Ctrl keys and perform necessary functions.
Printer Friendly Version
