You are currently offline, waiting for your internet to reconnect

Cannot Drag, Cut, or Copy AutoFilter Drop-down List

This article was previously published under Q105412
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
SYMPTOMS
In Microsoft Excel, you cannot drag, cut and paste, or copy and paste thedrop-down lists that are created when you use the AutoFilter to sort alist.
WORKAROUND
If you want to move the AutoFilter drop-down lists, you must move the dataand click the AutoFilter command again.
STATUS
This behavior is by design of Microsoft Excel.
MORE INFORMATION
Although it is not possible to drag, cut, or copy AutoFilter drop-downlists, you can move them if you insert or delete columns or rows that areto the left of, or above, the list range. For example, if there areAutoFilter drop-down lists in cells E10:G10, and you delete column A, thelists shift one column to the left; similarly, if you delete row 7, thelists shift up one row.
REFERENCES

Microsoft Excel 97 and Microsoft Excel 98 Macintosh Edition

For more information about using AutoFilter, click the Index tab or buttonin Microsoft Excel Help, type the following text

AutoFilter

and then double-click the selected text to go to the "Ways to find valuesin a list by using filters" topic.

Microsoft Excel 7.0

For more information about using AutoFilter, click the Index tab inMicrosoft Excel Help, type the following text

AutoFilter, overview

and then double-click the selected text to go to the "Filter a list"topic.

Microsoft Excel 5.0 for Windows and Macintosh

For more information about using AutoFilter, choose the Search button inHelp, and type:

AutoFilter

Choose the Show Topics button, select the topic "Overview of Filtering alist", and choose Go To.
5.00a 5.00c 97 98 XL98 XL97 XL7 XL5 XL
Properties

Article ID: 105412 - Last Review: 08/15/2003 15:12:42 - Revision: 1.1

  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 98 for Macintosh
  • KB105412
Feedback