Selection Techniques

Microsoft Excel - Selection Techniques

·  The selection techniques in Microsoft Excel allow you to select or highlight the cell(s) quickly so that you can perform the tasks such as deleting, copying, etc.

To select a cell

·  Click on the cell you wish to select.

·  To select a range of cells by dragging the mouse

·  Click on the first cell in the range.

·  Hold down the left-hand mouse button and drag over the cells you wish to include in the selection.

To select a range of cells (making up a rectangular block)

·  Click on the first cell of the rectangular block that you wish to select (i.e. the left top-left hand corner)

·  Move down to the cell that marks the bottom-right corner of the rectangular block.

·  Depress the Shift key (and keep it depress).

·  Click once on the last cell of the required block and release the Shift key.

To select a non-contiguous range

·  Select the first cell or range.

·  While holding down the Ctrl key, select the next range of cells.

To select a row

·  Click on the row heading number.

To select a column

·  Click on the column heading letter.

To select an entire worksheet

·  Press Ctrl+A