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.

Selecting Multiple Sheets

Contiguous sheets: Click the first sheet tab, hold down the Shift key and then click the last sheet tab to be selected.

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.