Tip 53: Selecting Cells Efficiently
Many Excel users think that the only way to select a range of cells is to drag over the cells with the mouse. Although selecting cells with a mouse works, it’s rarely the most efficient way to accomplish the task. A better way is to use your keyboard to select ranges.
Selecting a range by using the Shift and arrow keys
The simplest way to select a range is to press (and hold) Shift and then use the arrow keys to highlight the cells. For larger selections, you can use PgDn or PgUp while pressing Shift to move in larger increments.
You can also use the End key to quickly extend a selection to the last non-empty cell in a row or column. To select the range B3:B8 (see Figure 53-1) by using the keyboard, move the cell pointer to B3 and then press the Shift key while you press End followed by the down-arrow key. Similarly, to select B3:D3, press the Shift key while you press End, followed by the right-arrow key.
Figure 53-1...