Auto filter "ALL"
 

Auto filter.

Is there a quick way to restore the list to “ALL” after selecting a
particular a row to view.

Its a long list of names and “ALL” is at the top.

Johnny

Auto filter "ALL"
 

If you're using xl2003 or earlier, you can add a "show all" button to your
favorite toolbar.

Tools|Customize|Commands tab|Data Category
And drag "Show All" and maybe "Autofilter" to that favorite toolbar.

On 02/18/2011 06:14, Johnnyboy5 wrote:
Auto filter.

Is there a quick way to restore the list to “ALL” after selecting a
particular a row to view.

Its a long list of names and “ALL” is at the top.

Johnny

--
Dave Peterson

Auto filter "ALL"
 

Or accelerator keys:
Alt d f s

This works irrespective of Excel eddition.

On Feb 18, 12:21*pm, Dave Peterson wrote:
If you're using xl2003 or earlier, you can add a "show all" button to your
favorite toolbar.

Tools|Customize|Commands tab|Data Category
And drag "Show All" and maybe "Autofilter" to that favorite toolbar.

On 02/18/2011 06:14, Johnnyboy5 wrote:

Auto filter.

Is there a quick way to restore the list to ALL after selecting a
particular a row to view.

Its a long list of names and ALL is at the top.

Johnny

--
Dave Peterson

Auto filter "ALL"
 

On Feb 18, 12:50*pm, AB wrote:
Or accelerator keys:
Alt d f s

This works irrespective of Excel eddition.

On Feb 18, 12:21*pm, Dave Peterson wrote:



If you're using xl2003 or earlier, you can add a "show all" button to your
favorite toolbar.

Tools|Customize|Commands tab|Data Category
And drag "Show All" and maybe "Autofilter" to that favorite toolbar.

On 02/18/2011 06:14, Johnnyboy5 wrote:

Auto filter.

Is there a quick way to restore the list to ALL after selecting a
particular a row to view.

Its a long list of names and ALL is at the top.

Johnny

--
Dave Peterson- Hide quoted text -

- Show quoted text -

That works a treat - thanks VM

Auto filter "ALL"
 

On Feb 18, 12:21*pm, Dave Peterson wrote:
If you're using xl2003 or earlier, you can add a "show all" button to your
favorite toolbar.

Tools|Customize|Commands tab|Data Category
And drag "Show All" and maybe "Autofilter" to that favorite toolbar.

On 02/18/2011 06:14, Johnnyboy5 wrote:

Auto filter.

Is there a quick way to restore the list to ALL after selecting a
particular a row to view.

Its a long list of names and ALL is at the top.

Johnny

--
Dave Peterson

That also works a treat - thanks John