View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier
 
Posts: n/a
Default shortcut on autofilter function

Hi

ToolsCustomiseCommandsDatadrag Show All to your Toolbar.
If you want to give it an icon, whilst in this mode, right clickChange
Button image.

Regards

Roger Govier


derwood wrote:
i have many columns of data using the autofilter. is there a shortcut
that either returns all the fields to the all function or a shortcut
that returns all the data to the page

thanks