Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Excel autofilter stops filtering

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 15-10-2009
Member
 
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!!!

Reply With Quote
  #2  
Old 15-10-2009
Member
 
Join Date: May 2008
Posts: 4,828
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.
Reply With Quote
  #3  
Old 15-10-2009
Member
 
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.
Reply With Quote
  #4  
Old 15-10-2009
Member
 
Join Date: May 2008
Posts: 4,338
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.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 10:18 PM.