AutoFill Feature Overwrites Data within AutoFilter Range (111360)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0c
This article was previously published under Q111360 SUMMARY
In Microsoft Excel for Windows versions 5.x and 7.0, when you use the
AutoFill feature to fill a range of data that has an AutoFilter applied to
it, you may overwrite the underlying data.
WORKAROUND
To undo this change, choose Undo from the Edit menu immediately after you
fill the data. If Undo is not unavailable, the only way to recover the
data is to open a previously saved version of the file.
REFERENCES
"User's Guide," version 5.0, Chapter 21, "Filtering a List Using
AutoFilter"
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | KB111360 |
---|
|