Microsoft KB Archive/24949

From BetaArchive Wiki

Excel: Moving and Selecting Cells with the Keyboard

Last reviewed: November 2, 1994
Article ID: Q24949


You can select cells using the keyboard, instead of the mouse, in Microsoft Excel. The following keystrokes will change the cell selection:

   Key Combination   Action
   ---------------   ------

   TAB               Selects cell to right of active cell
   SHIFT+TAB         Selects cell to left of active cell
   RETURN            Selects cell below the active cell
   SHIFT+RETURN      Selects cell above active cell

If a range of cells is selected, you can use the OPTION key in combination with any of the above key combinations to move the entire selection in the same direction as above. For example, if cells A1:B5 are selected, you can select cells C1:D5 by pressing OPTION+TAB. For more information on moving and selecting in a worksheet, see Page 76 in the "Microsoft Excel User's Guide" version 3.00. If you are using Excel version 2.20, see Pages 419-422 of the "Microsoft Excel Reference" version 2.2 manual.

KBCategory: kbother


Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.