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

 Last reviewed: February 2, 1998
Article ID: Q105412
The information in this article applies to:
  • Microsoft Excel for Windows, versions 5.0, 5.0c
  • Microsoft Excel for the Macintosh, versions 5.0, 5.0a
  • Microsoft Excel for Windows NT, version 5.0
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Excel 97 for Windows
  • Microsoft Excel 98 Macintosh Edition

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.

Additional query words: 5.00 5.00a 5.00c 7.00 97 98 XL98 XL97 XL7 XL5
Keywords : xllist kbtlc
Version : WINDOWS:5.0,5.0c,7.0,97; MACINTOSH:5.0,5.0a,98
Platform : MACINTOSH WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.