Microsoft KB Archive/79270

{| = Excel: Using a Multiple Selection with Data Series =
 * width="100%"|

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 &quot;Microsoft Excel User's Guide&quot; 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
 Enter the number 1 in cell A1. Select cells A1:A5.  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.  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.