Prev: how do I lock a cell's format but still allow to edit it's value?
Next: adding largest numbers
From: tbear on 8 Mar 2010 15:06
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?
From: Gord Dibben on 8 Mar 2010 15:58
Generally one will copy the results of the filter to another
location...........maybe a new worksheet?

You cannot "show all" after a filter without removing the filtered results.


Gord Dibben MS Excel MVP

On Mon, 8 Mar 2010 12:06:01 -0800, tbear <tbear(a)discussions.microsoft.com>
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?

From: Dave Peterson on 8 Mar 2010 16:22
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
From: rzink on 8 Mar 2010 16:47
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 Home>Editing>Sort & 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?
 | 
Pages: 1
Prev: how do I lock a cell's format but still allow to edit it's value?
Next: adding largest numbers