Grouping excel work books

Group Adjacent Sheets

When the worksheets that you want to group are next to each other, you can use the [SHIFT] key to block select them.

To group adjacent worksheets:

·         Click the on the first worksheet’s tab that you want to include in your group.

·         Hold down the [SHIFT] key and click on the last worksheet’s tab that you want included in your group.  All the sheets between the first and the last will be selected.  The selected sheet tabs will turn white and the word “[group]” will appear on the title bar.

Group Non-Adjacent Sheets

When the sheets you want are not next to each other in the workbook, you can use the [CTRL] key to group them.

To group non-adjacent worksheets:

·         Click the on the first worksheet’s tab that you want to include in your group.

·         Hold down the [CTRL] key and click each other worksheet’s tab that you want included in your group.  The selected sheet tabs will turn white and the word “[group]” will appear on the title bar.

When worksheets are grouped, use normal data entry and formatting commands to populate them (see previous sections for more information).

Deactivate Group Mode

When you have finished entering and formatting data simultaneously, you can deactivate group mode.  There are two ways to do this:

To deactivate group mode:

·         Click on a sheet tab that is not currently grouped (non white).

Or

Click the right mouse button over any sheet tab and choose Ungroup Sheets from the shortcut menu.