Excel: SHIFT-Selecting Multiple Noncontiguous Ranges

ID: Q60486

The information in this article applies to:

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.

Additional query words: 1.0 1.00 1.03 1.04 1.06 1.5 1.50 2.20 3.0 4.00 macrosheet discontiguous discontinuous noncontinuous 


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 16, 1999