Selecting nonadjacent cells in Excel 2007

To select nonadjacent cells, perform any one of the following:

• Click a cell. Press and hold the CTRL key. Clicking the remaining cells.
• Click a cell. Press SHIFT and F8 keys. You will see Add to Selection in the Status bar. Click other cells. Once the selection of cells is over, press SHIFT and F8 keys.

Things you can do:
You can copy nonadjacent cells if the cells are in the same row or same column. The cells will be pasted into adjacent cells. In the image below, cells A1, C1, and E1 are copied and pasted in A3. They get pasted in cells A3, B3, and C3.

Things you cannot do:

• You cannot copy cells if the nonadjacent cells span across multiple rows and columns. You will receive the warning message saying That command cannot be used on multiple selections.
• You cannot drag and drop the cells that span across multiple rows and columns to another location.