Thread: how to return to full worksheet after filtering a colume?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default how to return to full worksheet after filtering a colume?
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
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?

Reply With QuoteReply With Quote