There's a Clear button to the right of the giant funnel/filter icon. You can
click it again to show all the data and still preserve the arrows.

But I'm not sure what you really mean about losing the filter...

tbear wrote:

I am using excel 2007 . I am trying to fillter the salemans region data. I
have managed to create the filter that I need. but can't return to the full
worksheet without loosing that filter. What am I doing wrong?

--

Dave Peterson