Microsoft Office Tutorials and References
In Depth Information
Navigating with special keys
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.
Understanding selection
As you will see, there are many ways beyond a simple click-and-drag to isolate the
particular types of data, formats, objects, and even blank cells that you need to gather or edit.
Here are a few pertinent facts and definitions to start with:
While a region is defined as a rectangular block of filled cells, a range is any rectangle
of cells, filled or empty.
Before you can work with a cell or range, you must select it, and when you do, it
becomes active .
The reference of the active cell appears in the Name box at the left end of the
formula bar.
You can select ranges of cells, but only one cell can be active at a time. The active
cell always starts in the upper-left corner of the range, but you can move it without
changing the selection.
Select all cells on a worksheet by clicking the Select All box located in the upper-left
corner of your worksheet, where the column and row headings intersect.
For more about selection, read on.
Search JabSto ::




Custom Search