Auto filter

Closed
sangita - 7 Dec 2011 à 04:56
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 8 Dec 2011 à 12:03
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 14 June 2009 Status Contributor Last seen 7 August 2021 811
7 Dec 2011 à 21:22
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
8 Dec 2011 à 12:03
There might be blank lines in between. Before applying or turning on the filter, select all the cells and then turn on the filter