Auto filter

Closed
sangita - Dec 7, 2011 at 04:56 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Dec 8, 2011 at 12:03 PM
Hello,



I have a file, where there are datas in 18000 rows. I am trying to do auto filter but it is not working properly. it is not taking the last few datas?

Can I pls know the reason?
Related:

2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 7, 2011 at 09:22 PM
too vague not clear. do you use macro or spreadsheet solution. post a small extract of the data and explain what you have done and what is the problem.
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Dec 8, 2011 at 12:03 PM
There might be blank lines in between. Before applying or turning on the filter, select all the cells and then turn on the filter