Microsoft Office Tutorials and References
In Depth Information
Navigating regions with the keyboard
Figure 6-1 There are four regions—blocks of “filled” cells—on this worksheet that are separate
regions.
Navigating regions with the keyboard
Here is a great way to move around fast without taking your hands off the keyboard. To
jump from edge to edge within and between regions, hold down the Ctrl key and then
press any of the arrow keys. For example, in Figure 6-1, cell A3 is the active cell; press
Ctrl+Right Arrow to activate cell E3. Press Ctrl+Right Arrow again and the active cell
jumps to G3, then H3, and finally XFD3—the last available cell in row 3. Just keep pressing
Ctrl+Left Arrow to return.
Navigating regions with the mouse
The dark border around the selected cell or cells is called a selection rectangle . When you
move the plus-sign pointer over the selection rectangle, the pointer becomes a
fourheaded arrow. When the arrow pointer is visible, double-click to jump from edge to edge
among regions—the mouse equivalent of the Ctrl+Arrow keyboard method described
earlier. For example, double-clicking the bottom of the single-cell selection rectangle in cell
A3, as shown in Figure 6-1, selects cell A7.
The left side of the status bar displays the mode indicators in Table 6-1 when the
corresponding keyboard mode is active.
TABLE 6-1 Keyboard modes
Mode
Description
Extend
Selection
Press F8 to turn on this mode, which you use to extend the current selection
using the keyboard. (Be sure that Scroll Lock is off.) This is the keyboard
equivalent of selecting cells by dragging the mouse. Furthermore, unlike
holding down the Shift key and pressing an arrow key, you can extend the
range by pressing only one key at a time. Press F8 again to turn off Extend
Selection mode.
Search JabSto ::




Custom Search