HOW TO: Use the Keyboard to Change the Active Cell in Excel 2000

SUMMARY

This step-by-step article describes how to use the keyboard to change the active cell in an Excel worksheet.

back to the top

Press CTRL+PERIOD

This method is an undocumented navigation keystroke. To do this, follow these steps:

1. Select a range of cells.
2. Press CTRL+PERIOD.
   
   The active cell moves clockwise to next corner.

back to the top

Use the Name Box

To use the Name box, follow these steps:

1. Use the mouse to click in the Name box in the upper left corner.
2. Type the cell address or name range in the Name box.
3. Press ENTER.

back to the top

Use the ARROW Keys, the ENTER Key, PAGE UP, or PAGE DOWN

To change the active cell, press any of the following keys:

• ARROW Keys: You can press the RIGHT ARROW key, LEFT ARROW key, UP ARROW key, or DOWN ARROW key to navigate in the worksheet.
• ENTER: According to how you set up your options in the Options dialog box, the cell one cell down or to the right becomes active when you press ENTER.
• PAGE UP or PAGE DOWN: Press PAGE UP or PAGE DOWN to move to the top or bottom of the page.

back to the top