Microsoft Office Tutorials and References
In Depth Information
Choosing a Select Group of Cells
The Shift key works with the mouse like an extend key to extend a selection
from the first object you select through to, and including, the second object
you select. See the section “Extend that cell selection,” later in this chapter.
Using the Shift key enables you to select the first and last cells, as well as all
the intervening cells in a worksheet or all the document names in a list.
If, when making a cell selection with the mouse, you notice that you include
the wrong cells before you release the mouse button, you can deselect the
cells and resize the selection by moving the pointer in the opposite direction.
If you already released the mouse button, click the first cell in the highlighted
range to select just that cell (and deselect all the others) and then start the
whole selection process again.
Nonadjacent cell selections
To select a nonadjacent cell selection made up of more than one non-touch-
ing block of cells, drag through the first cell range and release the mouse
button. Then hold down the Ctrl key while you click the first cell of the
second range and drag the pointer through the cells in this range. As long as
you hold down Ctrl while you select the subsequent ranges, Excel doesn’t
deselect any of the previously selected cell ranges.
On your onscreen virtual keyboard, you simply tap the Ctrl key to engage it —
you don’t have to keep it depressed as you do on a physical keyboard —
before you go about dragging through the other cell selections. Just remember
to tap the Ctrl key a second time to disengage when you’re all done selecting
your nonadjacent cells ranges.
The Ctrl key works with the mouse like an add key to include non-neighboring
objects in Excel. See the section “Nonadjacent cell selections with the
keyboard,” later in this chapter. By using the Ctrl key, you can add to the
selection of cells in a worksheet or to the document names in a list without having
to deselect those already selected.
Going for the “big” cell selections
You can select the cells in entire columns or rows or even all the cells in the
worksheet by applying the following clicking-and-dragging techniques to the
✓ To select every single cell in a particular column, click its column letter
on the frame at the top of the worksheet document window.
✓ To select every cell in a particular row, click its row number on the
frame at the left edge of the document window.