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

Article translations Article translations
Article ID: 105412 - View products that this article applies to.
This article was previously published under Q105412
Expand all | Collapse all

On This Page

SYMPTOMS

In Microsoft Excel, you cannot drag, cut and paste, or copy and paste the drop-down lists that are created when you use the AutoFilter to sort a list.

WORKAROUND

If you want to move the AutoFilter drop-down lists, you must move the data and 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-down lists, you can move them if you insert or delete columns or rows that are to the left of, or above, the list range. For example, if there are AutoFilter drop-down lists in cells E10:G10, and you delete column A, the lists shift one column to the left; similarly, if you delete row 7, the lists 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 button in Microsoft Excel Help, type the following text

AutoFilter

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

Microsoft Excel 7.0

For more information about using AutoFilter, click the Index tab in Microsoft 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 in Help, and type:

AutoFilter

Choose the Show Topics button, select the topic "Overview of Filtering a list", and choose Go To.

Properties

Article ID: 105412 - Last Review: August 15, 2003 - Revision: 1.1
APPLIES TO
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 98 for Macintosh
Keywords: 
KB105412
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.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com