Excel: Using a Multiple Selection with Data Series

 Last reviewed: November 3, 1994
Article ID: Q79270
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.1, 3.0, 4.0
  • Microsoft Excel for OS/2, versions 2.2 and 3.0

SUMMARY

Page 263 of the "Microsoft Excel User's Guide" states that you can perform a data series using a multiple selection. This works, but you must have all discontiguous selections within the same column or row.

MORE INFORMATION

The Data Series command allows you to enter a series of dates or numbers automatically into a range of cells. The series can be entered into a multiple selection when the starting value resides in the first cell of the first discontiguous range. However, the data series will not function if the discontiguous selections are not aligned. If the data series is vertical, all discontiguous selections must be made in the same column. If the data series is horizontal, all discontiguous selections must be made in the same row.

Example

  1. Enter the number 1 in cell A1.

  2. Select cells A1:A5.

  3. Press the CTRL key and select cells A7:A11 with your mouse. 

          -or-

    From the keyboard, press SHIFT+F8 and press the DOWN ARROW key to move down to cell A7. Then, hold down the SHIFT key and press the DOWN ARROW key to move to cell A11.

  4. From the Data menu, choose Series and then choose OK.

The series will be created, skipping cell A6. However, if you attempt to reproduce the same example above using cells B7:B11 as the second selection, the series will be created in column A only. The same results occur with a horizontal (row oriented) series.

REFERENCES

"Microsoft Excel User's Guide," version 3.0, pages 261-264

KBCategory: kbother
KBSubcategory:

Additional reference words: date linear growth step increment stop 2.10
2.10c 2.10d 3.00 2.20 2.21 2.1 2.1c 2.1d 2.2 docerr document error
create

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