Picking a Contiguous Range of Cells

There are many times when you are working with Excel when you need to select a range of cells. This is very easy to do using either the keyboard, the mouse, or a combination of both.

The first step in selecting a range of cells is to select the first cell in the range. With the cell selected you are ready to proceed.

• Using the keyboard, you can hold down the Shift key as you use the navigation keys (up, down, left, and right arrows) to extend the range.
• Using the mouse, you can click on the first cell and hold down the mouse button as you drag the mouse to extend the range.
• Using the keyboard and mouse, you can hold down the Shift key as you click on the cell that defines the opposite corner of the range you want selected.