Thread: Filters
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Filters

I've dragged the ShowAll icon to my favorite toolbar.

Tools|Customize|commands tab|data category
scroll down looking for "Show All" and drag it to your toolbar.

Kathy wrote:

Is there a quicker way to reset filters then clicking on Data - filter -
show all?
Can I assign a cell to work as a "reset button"? If so how?


--

Dave Peterson