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

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

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.

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.

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.