Excel: Can't Select Multiple Cells with Some Mac Keyboards

Last reviewed: November 2, 1994
Article ID: Q48196

SUMMARY

Page 419 in the "Microsoft Excel Reference" version 2.2 manual states that by pressing SHIFT+<arrow key> a selection can be extended in the direction of the key.

This procedure does not work on a Macintosh XL, 128K, 512K, or Plus keyboard. This limitation occurs because the above computers internally map the shifted arrow keys within the computer to the keypad "=", "/", "*", and "+" keys. Excel has no way to distinguish between SHIFT+<arrow key> and the keypad mappings.

To extend the current selection from the keyboard on one of the above machines, enter EXTEND mode by pressing Keypad MINUS with NUM LOCK turned off (if you are in NUM LOCK mode, press SHIFT+CLEAR to turn off NUM LOCK, then press Keypad MINUS). The unshifted arrow keys then will work the same as the shifted direction keys on a Macintosh SE or Macintosh II.

To make the direction keys work again as regular direction keys, press Keypad MINUS again to toggle EXTEND mode to off. When EXTEND mode is enabled, EXT displays in the right-hand side of the status bar, if the status bar is displaying.


KBCategory: kbdocerr
KBSubcategory:

Additional reference words: 2.20


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

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