XL97: CTRL + Autofill Does not Increment Values

ID: Q159319

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

When you press the Control key and drag the fill handle to autofill cells, the value in the destination cells does not increment.

CAUSE

When you Autofill from a cell with Merge Cell formatting, values do not increment when you press the Control key 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 without using the Control key.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

REFERENCES

For more information about filling cells, click the Index tab in Microsoft Excel Help, type the following text

   filling cells

and then double-click the selected text to go to the "Automatically fill in data based on adjacent cells" topic.

Additional query words: XL97 8.00 97 autofill

Keywords          : xlformat 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: November 4, 1998