Select an Entire Rows or Columns : Selection « Editing « Microsoft Office Excel 2007 Tutorial






To select a single row or column, click in the row or column heading
To select a single row or column, click in the row or column heading
To select multiple adjacent rows or columns, drag in the row or column headings.
To select multiple adjacent rows or columns, drag in the row or column headings.
To select multiple nonadjacent rows or columns, 
           press Ctrl while you click the borders for the rows or columns.
To select multiple nonadjacent rows or columns, press Ctrl while you click the borders for the rows or columns.








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