Microsoft Office Tutorials and References
In Depth Information
Selecting Cells with the Keyboard
Figure 2–3. Selecting rows and columns, as we start to drag to the right
Selecting Cells with the Keyboard
You can also select cells with the keyboard. Click in the first cell you want to select,
release the mouse, and then
Hold down the Shift key.
Leaving the Shift key down, tap any of the arrow keys in the direction of
the cells you want to select.
You can change arrow keys as you proceed, so that you can select cells
to the right of the start cell by tapping the right arrow key, and then
begin to select cells downward by tapping the down arrow key.
Selecting All the Cells
Now back to that Select All button:
Figure 2–4. Remember—it’s to the left of the A column heading, and above row heading 1.
Remember that clicking Select All highlights all the worksheet cells at the same time—all
1.7 billion or so of them. You’d turn to Select All, then, if you wanted reformat all those
cells uniformly—say to implement the same font change in all of them. (Note: clicking
Ctrl-A will also normally select all worksheet cells. (There’s an exception to this rule,
though: if you click anywhere in a group of consecutive cells that contain data—called a
range, a topic which is coming next—Ctrl-A will select only those cells.)
Search JabSto ::

Custom Search