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.

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