How do i view only the filtered results from autofilter ?

If a use an autofilter on a long list of data, it shows the filtered items at
the top of the page with blue line numbers, but it also shows the remaining
results underneath. Is there anyway of just showing the filtered results ?
thanks

Hi Simon,

I think you have a empty row between your data, if it's true, exclude the
row and try to filter again
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"simon" escreveu:

> If a use an autofilter on a long list of data, it shows the filtered items at
> the top of the page with blue line numbers, but it also shows the remaining
> results underneath. Is there anyway of just showing the filtered results ?
> thanks

thanks, that works a treat. Very Clever.........

"Marcelo" wrote:

> Hi Simon,
>
> I think you have a empty row between your data, if it's true, exclude the
> row and try to filter again
> hth
> --
> regards from Brazil
> Thanks in advance for your feedback.
> Marcelo
>
>
>
> "simon" escreveu:
>
> > If a use an autofilter on a long list of data, it shows the filtered items at
> > the top of the page with blue line numbers, but it also shows the remaining
> > results underneath. Is there anyway of just showing the filtered results ?
> > thanks

thanks for the feedback

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"simon" escreveu:

> thanks, that works a treat. Very Clever.........
>
> "Marcelo" wrote:
>
> > Hi Simon,
> >
> > I think you have a empty row between your data, if it's true, exclude the
> > row and try to filter again
> > hth
> > --
> > regards from Brazil
> > Thanks in advance for your feedback.
> > Marcelo
> >
> >
> >
> > "simon" escreveu:
> >
> > > If a use an autofilter on a long list of data, it shows the filtered items at
> > > the top of the page with blue line numbers, but it also shows the remaining
> > > results underneath. Is there anyway of just showing the filtered results ?
> > > thanks