Microsoft Office Tutorials and References
In Depth Information
Formatting the Worksheet
2
Press the ENTER key to change the active cell in the Name box and make cell A3 the active cell (Figure 1– 54).
cell A3 is active cell
Figure 1– 54
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 specic 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.
Search JabSto ::




Custom Search