Results 1 to 4 of 4

Thread: Excel autofilter stops filtering

  1. #1
    Join Date
    Aug 2009
    Posts
    27

    Excel autofilter stops filtering

    I am using excel 2003 on my windows xp computer. I have noticed that my autofilter just stoped filtering completely after entering 20 new row. What has happened and what is the solution?Can anyone help!!!

  2. #2
    Join Date
    May 2008
    Posts
    4,834

    Re: Excel autofilter stops filtering

    The basic Excel filter allows you to view specific rows in an Excel spreadsheet, while hiding the other rows in the worksheet.An AutoFilter dropdown list will only show 1000 entries. As a result, in a large database, the AutoFilter dropdown may not show all the items in the column.

  3. #3
    Join Date
    Dec 2008
    Posts
    371

    Re: Excel autofilter stops filtering

    Did you check the option to check in the values instead of the formulas?When the autofilter stops responding, perhaps it has something to do with the range.

  4. #4
    Join Date
    May 2008
    Posts
    4,348

    Re: Excel autofilter stops filtering

    AutoFilter is an easy way to turn the values in Excel column into specific filters based on the cell contents. AutoFilter option is an automatic process that does not receive any specific inputs on how to filter, it is recommended that you choose ‘’all’’ of the data you have.

Similar Threads

  1. Automatic filtering in Excel
    By RenNoClue in forum Software Development
    Replies: 4
    Last Post: 27-01-2012, 07:08 PM
  2. how to enable Autofilter and Sorting in Protected Excel Sheet
    By ChittiBabu in forum Windows Software
    Replies: 2
    Last Post: 04-01-2012, 07:38 PM
  3. How to Use Excel filtering to find data quickly
    By manishdk in forum Guides & Tutorials
    Replies: 1
    Last Post: 31-12-2009, 12:18 PM
  4. Microsoft Excel autofilter has stopped working
    By McGrawh in forum Windows Software
    Replies: 4
    Last Post: 07-05-2009, 02:31 PM
  5. Sorting and filtering Microsoft Excel
    By CLONEOPS in forum Windows Software
    Replies: 2
    Last Post: 09-01-2009, 10:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •