Thanks for the idea. This way I can keep my header and footer of the
document....but this deletes the header "row" as well....but I can always
copy and paste another header row...thanks.

"Gord Dibben" wrote:

Maybe you can filter on Custom"Does not equal"

Then do the F5SpecialVisible cells only and EditDeleteRow


Gord Dibben MS Excel MVP

On Wed, 28 May 2008 06:56:00 -0700, annoni
wrote:

Thanks for the tip..I've just tried it...it works! But I am still wondering
if there's a way to save the result on the same worksheet instead of copying
and pasting on a new worksheet. If there is no such trick, I guess I will
just use F5 key. Thanks.


"Marcelo" wrote:

After filtered, select the range press F5 - Special - Visivable cells only,
copy, and paste in a new sheet and save it. delete the old if you want

hth

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



"annoni" escreveu:

After filtering a list, how do I save only the filtered result "as it is
shown" on
the same worksheet and discard the rest? Please help...thanks.