Selecting adjacent cells in Excel 2007

Select adjacent cells by clicking a cell and dragging the mouse over a group of cells. This works good if the selection area is small. If the selection area is large then click the first cell in the selection area. Press and hold down the SHIFT key. Click the last cell to make the selection.

Alternative ways to select adjacent cells:
1. Click the first cell. Press and hold the SHIFT key. Press the RIGHT or LEFT arrow key to make the selection of cells in the row. With the SHIFT key still in pressed state, press the UP or DOWN key to make the selection of columns.
2. Click the first cell. Press the F8 key. You will see Extend Selection in the Status bar. Click the last cell in the selection area. Press F8 key again.

Things to notice when selecting adjacent cells:
1. The Name box will display the number of rows and columns selected while performing the selection process.
2. The column and row headers will be shaded to identify the selected rows and columns.
3. One cell in the selected cells is active and is highlighted in white.

Things you can do:
1. You can copy or move the data in the selected cells to another location.
2. You can enter data in the selected cells.
3. You can enter data in a cell and copy the data to all cells in the selected area.