Microsoft Office Tutorials and References
In Depth Information
Selecting Cells Efficiently
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 4-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 4-1: A range of cells.
Selecting the current region
Often, you need to select a large rectangular selection of cells — the current region . To select the
entire block of cells, move the cell pointer anywhere within the range and press Ctrl+A.
Selecting a range by Shift+clicking
When you’re selecting a very large range, using the mouse may be the most efficient method —
but dragging is not required. Select the upper left cell in the range. Then scroll to the lower right
corner of the range, press Shift, and click the lower right cell.
Selecting noncontiguous ranges
Most of the time, your range selections are probably simple rectangular ranges. In some cases,
you may need to make a multiple selection — a selection that includes nonadjacent cells or
 
Search JabSto ::




Custom Search