Microsoft KB Archive/200724

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

Article ID: 200724

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q200724



IN THIS TASK
SUMMARY
 * Press CTRL+PERIOD
 * Use the Name Box
 * Use the ARROW Keys, the ENTER Key, PAGE UP, or PAGE DOWN



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

Additional query words: moving cursor

Keywords: kbhowtomaster KB200724

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.