Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

AutoFill feature overwrites data within AutoFilter range

View products that this article applies to.


In the versions of Microsoft Excel that are listed in the "Applies to" section, you use the AutoFill feature to fill a range of data that has an AutoFilter applied to it. When you do this, the underlying data may be overwritten.

↑ Back to the top


To undo this change, click Undo on the Edit menu immediately after you fill the data. If the Undo option is unavailable, the only way to recover the data is to open a previously saved version of the file.

↑ Back to the top

More information

Steps to reproduce the behavior

  1. Create a new worksheet in Excel. Starting with the word "Number" in cell A1, create a range of data as follows:
       A1 Number   B1  Letter
       A2   1      B2    A
       A3   2      B3    B
       A4   3      B4    A
       A5   4      B5    B
       A6   3      B6    A
       A7   5      B7    B
       A8   4      B8    A
  2. Select any cell within this range (A1:B8).
  3. On the Home tab, click Filter on the editing menu.
  4. Drop-down lists will appear in cells A1 and B1. Select A on the drop-down list in cell B1.
  5. Rows three, five, and seven are hidden. Select cells A2 through A8. Perform an AutoFill by dragging the selection down three cells (to cell A11).
Notice that the numbers in cells A2 through A11 change to 1.

↑ Back to the top

Keywords: KB111360

↑ Back to the top

Article Info
Article ID : 111360
Revision : 2
Created on : 3/15/2007
Published on : 3/15/2007
Exists online : False
Views : 472