Excel: SHIFT-Selecting Multiple Noncontiguous Ranges

 Last reviewed: November 29, 1994
Article ID: Q60486
The information in this article applies to:
  • Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

SUMMARY

To SHIFT-select multiple noncontiguous ranges in a Microsoft Excel worksheet or macro sheet, use the following procedure:

  1. Click the first cell.

  2. Hold down the SHIFT key and select the ending cell for that range. Release the SHIFT key.

  3. Hold down the COMMAND key and select the first cell of the second range. Release the COMMAND key.

  4. Hold down the SHIFT key and select the end of the range. Release the SHIFT key.

Repeat steps 3 and 4 for each noncontiguous range to add to the selection.

NOTE: The SHIFT+COMMAND key combination will not work because this combination cancels all previously selected text.

KBCategory: kbusage
KBSubcategory:

Additional reference words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.2 2.20
3.0 3.00 4.0 4.00 macrosheet discontiguous discontinuous noncontinuous

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 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.