Microsoft Excel Filters (last row doesn't filter)

  • Thread starter Thread starter NathanGRobinson
  • Start date Start date
N

NathanGRobinson

Hi,

I'm using tables in MS Excel 2007 (I also remember having similar issues
with 2003). The table contains static data, text and formulas. I'm using the
auto-filter function, but for some reason some of the rows aren't filtering
properly. At the moment, the table has 70 rows in it, but when I filter, it
doesn't filter the final 4 rows. (eg: I filter column D for the value 22,
which works up to row 66, but the final 4 rows stay in the table regardless).
Upon unfiltering the data, some of the rows remain hidden. I've no idea why
this is happening. I've tried turning the auto-filter on and off but to no
avail. FYI: The formatting doesn't change between any of the rows. Any ideas?
 
Hi Roger,

Thanks for your response. I've double checked the table and all rows are
included in the range. I've actually also discovered that if I continue to
filter the same column over and over again, each time I do so, an extra row
is dropped off the bottom as a non-filtered line.

Am I possibly looking at a corrupted worksheet?
 
Hi Nathan

I have similar issue. How has yours been solved?

thanks
Luc
l
NathanGRobinson said:
Hi Roger,

Thanks for your response. I've double checked the table and all rows are
included in the range. I've actually also discovered that if I continue to
filter the same column over and over again, each time I do so, an extra row
is dropped off the bottom as a non-filtered line.

Am I possibly looking at a corrupted worksheet?

"Roger Govier" wrote:

> Hi Nathan
>
> With your cursor within the table, select Design tab>Properties>Resize Table
> What does it show for the current range?
> If it does not include all of your rows, then re-select the are concerned
> and click OK.
>
> --
> Regards
> Roger Govier
>
> "NathanGRobinson" <(e-mail address removed)> wrote in
> message news:(e-mail address removed)...
> > Hi,
> >
> > I'm using tables in MS Excel 2007 (I also remember having similar issues
> > with 2003). The table contains static data, text and formulas. I'm using
> > the
> > auto-filter function, but for some reason some of the rows aren't
> > filtering
> > properly. At the moment, the table has 70 rows in it, but when I filter,
> > it
> > doesn't filter the final 4 rows. (eg: I filter column D for the value 22,
> > which works up to row 66, but the final 4 rows stay in the table
> > regardless).
> > Upon unfiltering the data, some of the rows remain hidden. I've no idea
> > why
> > this is happening. I've tried turning the auto-filter on and off but to no
> > avail. FYI: The formatting doesn't change between any of the rows. Any
> > ideas?
>
Click to expand...
 
Back
Top