XL2000: CTRL + Autofill Does Not Increment the Values in the Destination Cells (212222)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q212222

SYMPTOMS

When you press the CTRL key and drag the fill handle to autofill cells, the values in the destination cells do not increment.

CAUSE

When you autofill from a cell with Merge Cell formatting, values do not increment when you press CTRL and drag the fill handle. This behavior is the opposite of behavior exhibited by non-merged cells.

WORKAROUND

In order for the filled cells to increment as expected, use the fill handle on the merged cell but do not press CTRL.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For more information about filling cells, click Microsoft Excel Help on the Help menu, type automatically filling in data based on adjacent cells in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Modification Type:MajorLast Reviewed:11/5/2003
Keywords:kbbug kbpending KB212222
©2003 Microsoft Corporation. All rights reserved.