how dose filter works to last cell in the column
in [General]
|
Prev: Adding fractions and displaying as Percentages
Next: How do I set expiry document dates on Excel 2003?
From: Khalid on 29 Apr 2010 01:04 some time fillter do not show existing cells
From: SarahN on 29 Apr 2010 01:20 A filter only calculates to the next empty Cell. So if there is an empty cell in the column it will not go to last cell. Hope this helps. "Khalid" wrote: > some time fillter do not show existing cells
From: Dave Peterson on 29 Apr 2010 08:03
I never let excel guess at the range to filter. I always select the range I want, then apply the filter. Maybe you could try removing the filter, reselecting the range, reapplying the filter and then filter once more. If that doesn't help, you'll have to add more details -- what you're filtering text (including length of text), dates, times how you're filtering (contains, greater, equal...) and how it fails. Khalid wrote: > > some time fillter do not show existing cells -- Dave Peterson |