Select Multisheet Ranges : Selection « Editing « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Editing
3. Selection

Select the range in one sheet.

Select the worksheets to include in the range.

To select contiguous worksheets, 
           press Shift and click the last sheet tab you want to include.

To select non-contiguous worksheets, 
           press Ctrl and click the sheets you want.

When you make a worksheet selection, Excel enters Group mode.

To exit Group mode, click any sheet tab.

2.8.Selection
	2.8.1.	Select a Contiguous Range
	2.8.2.	Select a Non-contiguous Range
	2.8.3.	Select an Entire Rows or Columns
	2.8.4.	Select Multisheet Ranges
	2.8.5.	Make a selection from within a range