How to apply filter on a column

Closed
A - Sep 21, 2010 at 08:51 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Sep 21, 2010 at 09:49 AM
Hello,
I have an excel sheet with 2,00,000 records and unable to apply the filter for all the records.Colud u help me in solving this.(The filter is being applied only on 10000 rows).
I'm working with 2007


2 responses

Saman.tha Posts 1381 Registration date Monday May 25, 2009 Status Moderator Last seen September 14, 2015 33
Sep 21, 2010 at 09:31 AM
Hi,

I just have about 1000 entries in a column, but it works when I choose the whole column with the little black arrow on the top of each column (click on A or another column).

But, as you've got a vast amount of records in your sheet, I'm not quite sure whether the size is the problem. Maybe the advanced filter will do the trick.

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Sep 21, 2010 at 09:49 AM
One reason could be that you have blank rows/cell in between. Get out of the filter mode completely, select all the cell, re-apply the filters. See if that helps