Selecting a region in Excel 2007

A region is a group of cells with data and is bounded by blank cells around it (or) a block of cells that includes the currently selected cell or cells and is bounded by blank columns and rows. To select a region, do one of the following:

• Press CTRL + SHIFT + *. The * that is above the number 8 and not the * in the number pad.
• 1. On the Home tab, in the Editing group, click Find & Select and then click Go To Special...
  2. In the Go To Special dialog box, click Current region.
  3. Click OK.