Selecting rows in Excel 2007

By default, every row looks alike. To identify the rows, Excel displays row header with numbers. Row header appear at the left most part of the worksheet area.

Selecting a single row: (Perform any one of the following)

• Click the row header.
• Click a cell that corresponds to the row. Press SHIFT + SPACEBAR.
• Click the first cell in the row and press CTRL + SHIFT + RIGHT arrow keys. If data is present then the selection is made till the end of the cells that contain the data. Press CTRL + SHIFT + RIGHT arrow keys again to select the entire row provided that no data is present in between.

Selecting multiple rows:

• You can select adjacent rows by clicking the row header and pressing the SHIFT key and clicking the last row number in the row header.
• You can select nonadjacent rows by selecting the first row (click the row number) and pressing the CTRL key and clicking other row numbers in the row header.