Thread: show all button
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Derwood Derwood is offline
external usenet poster
 
Posts: 5
Default show all button

On Jan 29, 12:55 am, Dave Peterson wrote:
Every so often, it's not a bad idea to skim through all the built in icons.
Every version of excel adds more (or changes existing???). So it's difficult to
keep track of what's important.



SteveW wrote:

Mental note, must stop forgetting those that don't have a default icon :)
Steve


On Sun, 28 Jan 2007 12:42:56 -0000, Dave Peterson
wrote:


You can add a "Show All" button to your favorite toolbar (especially
handy if
you want to reset all the filters quickly).


Tools|Customize|Commands Tab|Data Category


Drag that "Show All" command to your favorite toolbar.


Derwood wrote:


hi
how do i get the show all button to appear in the task bar
thanks


--

Dave Peterson


ok
in the version of excel 2002 once the show all is selected it does not
work nor highlighted when the protection is on. no problem though when
protection is deselected... any suggestions would be appreciated.