Select a Contiguous Range : Selection « Editing « Microsoft Office Excel 2007 Tutorial






Click the first cell that in the range. 
           Drag the mouse to the last cell in the range.
Click the first cell that in the range. Drag the mouse to the last cell in the range.
Or Click the first cell, then hold down the Shift key, 
           and then click the lower-right cell in the range.
Or Click the first cell, then hold down the Shift key, and then click the lower-right cell in the range.








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