Filter

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is there a limit to what can be filtered? I have a worksheet that contains
about 30,000 lines, and I just noticed that the last two lines I entered are
not on the fileter.
 
1. remove the filter
2. select ALL the cells in the column to which you want the filter applied
3. re-assert the filter
 
Still Didn't work

Gary''s Student said:
1. remove the filter
2. select ALL the cells in the column to which you want the filter applied
3. re-assert the filter
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to I advance filter to remove rows containing partic string of text? 3
Problem with Calculated item in Pivot Table 1
Custom Filtering - Limitations of the "Contains" option 7
Does Excel support Auto fill on filtered data? 1
Autofilter results 3
Filter not working 1
Formulas based on Pivot Table 3
How do I copy filtered rows in excel 1

Back
Top