Microsoft Office Tutorials and References
In Depth Information
Selecting with the mouse
Selecting columns, rows, and nonadjacent ranges
A nonadjacent range (also known as multiple or noncontiguous ) comprises more than one
selection rectangle, as shown in Figure 6-3. To select multiple ranges with the mouse, press
the Ctrl key and drag through each range you want to select. The first cell you click in the
last range you select becomes the active cell. As you can see in Figure 6-3, cell G6 is the
Figure 6-3 Hold down the Ctrl key and drag to select nonadjacent ranges with the mouse
Use the following methods to select using the mouse:
● To select an entire column or row, click the column or row heading. The first visible
cell in the column becomes the active cell. If the first row visible on your screen is
row 1000, cell A1000 becomes active when you click the heading for column A, even
though all the other cells in the column are selected.
To select more than one adjacent column or row at a time, drag through the column
or row headings, or click the heading at one end of the range, press Shift, and then
click the heading at the other end.
To select nonadjacent columns or rows, hold down Ctrl and click each heading or
drag through adjacent headings you want to select.
In Figure 6-4, we clicked the heading in column A and then pressed Ctrl while dragging
through the headings for rows 1, 2, and 3.