Excel: Filled Series Not Incremented with Cell ReferenceLast reviewed: September 12, 1996 |
The information in this article applies to:
SYMPTOMSPage 125 of the "Users Guide 1," suggests that you can create a series by entering data into two cells, selecting those cells, and dragging the fill handle. While this method works for most types of data, it does not work if the cells contain cell references. When you attempt to fill a selection that contains a cell reference, the series is not incremented correctly. WORKAROUNDTo work around this problem, do the following:
Your result is an incremented cell reference. MORE INFORMATIONSteps to Reproduce the Behavior
REFERENCES"User's Guide 1," version 4.0, pages 124-125 |
KBCategory: kbother Last reviewed: September 12, 1996 |