tbear

There are at least 3 methods:

1) go to the column that is filtered, click on the dropdown arrow and select
"Clear Filter"
2) on the top menu, go to HomeEditingSort & Filter and select "Clear"
(this is useful if you have multiple columns that are filtered and you don't
want to have to clear the filter on each column individually.
3) this is a keyboard shortcut held over from XL2003; Alt-D F S. This is
the same as #2 above.

Hope this helps.

rzink


"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?