Microsoft Office Tutorials and References
In Depth Information
Using the Name Box to Select a Cell
2
Press the
ENTER key
to change the active
cell in the Name box
(Figure 1– 52).
A3 is active cell
Figure 1–52
Other Ways to Select Cells
As you will see in later chapters, in addition to using the Name box to select any cell in a worksheet, you
also can use it to assign names to a cell or range of cells. Excel supports several additional ways to select a cell,
as summarized in Table 1– 3.
Table 1– 3 Selecting Cells in Excel
Key, Box, or Command
Function
ALT + PAGE DOWN
Selects the cell one worksheet window to the right and moves the worksheet window accordingly.
ALT + PAGE UP
Selects the cell one worksheet window to the left and moves the worksheet window accordingly.
Selects the adjacent cell in the direction of the arrow on the key.
ARROW
CTRL + ARROW
Selects the border cell of the worksheet in combination with the arrow keys and moves the worksheet
window accordingly. For example, to select the rightmost cell in the row that contains the active cell, press
CTRL + RIGHT ARROW . You also can press the END key, release it, and then press the appropriate arrow key to
accomplish the same task.
CTRL + HOME
Selects cell A1 or the cell one column and one row below and to the right of frozen titles and moves the
worksheet window accordingly.
Find command on Find
and Select menu or SHIFT + F5
Finds and selects a cell that contains specii c contents that you enter in the Find and Replace dialog box. If
necessary, Excel moves the worksheet window to display the cell. You also can press CTRL + F to display the Find
dialog box.
Go To command on Find
and Select menu or F5
Selects the cell that corresponds to the cell reference you enter in the Go To dialog box and moves the
worksheet window accordingly. You also can press CTRL + G to display the Go To dialog box.
Selects the cell at the beginning of the row that contains the active cell and moves the worksheet window
accordingly.
HOME
Name box
Selects the cell in the workbook that corresponds to the cell reference you enter in the Name box.
PAGE DOWN
Selects the cell down one worksheet window from the active cell and moves the worksheet window accordingly.
PAGE UP
Selects the cell up one worksheet window from the active cell and moves the worksheet window accordingly.
Break Point: If you wish to take a break, this is a good place to do so. Be sure to save the Save Sable River Foundation i le
again and then you can quit Excel. To resume at a later time, start Excel, open the i le called Save Sable River Foundation,
and continue following the steps from this location forward.
Search JabSto ::




Custom Search