Moving Around Regions

A region is a rectangular range of cell entries, or a block of “filled cells.” In Figure 6-1, the range A3:E7 is a region, as are the ranges G3:H7, A9:E10, and G9:H10. (Strictly speaking, cell A1 is a one-cell region, too.) For example, cell H10 is within a region, even though it’s empty.

The active area of the worksheet is the selection rectangle that encompasses all regions—that is, all the filled cells in the active worksheet—which in Figure 6-1 is A1:H10.

The techniques you can use to navigate regions are helpful if you typically work with large tables of data. Getting to the bottom row of a 500-row table is easier when you don’t have to use the scroll bars.

There are four regions—blocks of “filled” cells—on this worksheet that are separate regions.

Figure 6-1. There are four regions—blocks of “filled” cells—on this worksheet that are separate regions.

Note

The small square in the lower-right corner of the active cell is the fill handle. If the fill handle isn’t visible on your screen, it means it isn’t turned on. To turn it on, click the File tab, click Options, click the Advanced category, and select the Enable Fill Handle And Cell Drag-And-Drop check box.

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 four-headed 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 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.

Add To Selection

Press Shift+F8 to add more cells to the current selection using the keyboard; the cells need not be adjacent. After pressing Shift+F8, click any cell or drag through any range to add it to the selection. This is the keyboard equivalent of holding down Ctrl and selecting additional cells with the mouse.

Num Lock

Keeps your keypad in numeric entry mode. This is turned on by default, but its status is not usually displayed in the status bar. However, you can make it so by right-clicking the status bar anywhere and clicking Num Lock.

Fixed Decimal

To add a decimal point to the numeric entries in the current selection, click the File tab, click Options, select the Advanced category, and select the Automatically Insert A Decimal Point check box in the Editing Options group. Excel places the decimal point in the location you specify in the Places box. For example, when you turn on Fixed Decimal mode, specify two decimal places, and type the number 12345 in a cell, the value 123.45 appears in the cell after you press Enter. Existing cell entries are not affected unless you edit them. To turn off Fixed Decimal mode, return to the Advanced category in the Excel Options dialog box and clear the Automatically Insert A Decimal Point check box.

Caps Lock

Press the Caps Lock key to type text in capital letters. (This does not affect number and symbol keys.) To turn off Caps Lock mode, press the Caps Lock key again. The status of this mode does not usually display in the status bar, but you can make it so. Right-click the status bar anywhere, and click Caps Lock.

Scroll Lock

Press Scroll Lock to use the Page Up, Page Down, and arrow keys to move the viewed portion of the window without moving the active cell. When Scroll Lock mode is off, the active cell moves one page at a time when you press Page Up or Page Down and moves one cell at a time when you press one of the arrow keys. To turn off Scroll Lock mode, press the Scroll Lock key again.

End Mode

Press the End key, and then press an arrow key to move the selection to the edge of the region in that direction or to the last worksheet cell in that direction. This mode functions like holding down Ctrl and pressing an arrow key, except you need to press only one key at a time. To turn off End mode, press the End key again. End mode is also turned off after you press one of the arrow keys.

Overtype Mode

Click the formula bar or double-click a cell and press the Insert key to turn on Overtype mode (formerly known as Overwrite mode). Usually, new characters you type in the formula bar are inserted between existing characters. With Overtype mode turned on, the characters you type replace any existing characters to the right of the insertion point. Overtype mode turns off when you press Insert again or when you press Enter or one of the arrow keys to lock in the cell entry. The status of this mode does not usually display in the status bar, but you can make it so. Right-click the status bar anywhere, and click Overtype Mode.

Navigating with Special Keys

Table 6-2 shows how you can use the Home and End keys alone and in conjunction with other keys to make selections and to move around a worksheet.

Table 6-2. Keyboard Shortcuts for Navigation

Press

To

Home

Move to the first cell in the current row.

Ctrl+Home

Move to cell A1.

Ctrl+End

Move to the last cell in the last column in the active area. For example, in Figure 6-1, pressing Ctrl+End selects cell H10.

End

Start End mode, and then press an arrow key to move around by cell region.

Scroll Lock+Home

Move to the first cell within the current window.

Scroll Lock+End

Move to the last cell within the current window.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset