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.
0
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
0