Microsoft KB Archive/60486

{|
 * width="100%"|

Excel: SHIFT-Selecting Multiple Noncontiguous Ranges

 * }

-

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.

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 :

Technology :