| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing default "Group dates in the Auto Filter menu" | Excel Programming | |||
| Marco to open the "Customer Auto filter dialog box" | Excel Programming | |||
| Auto Filter - how to collapse "non-blank" cells in a column? | Excel Discussion (Misc queries) | |||
| how to auto "copy & paste" (or filter) from a Master spreadsheet? | Excel Worksheet Functions | |||
| How do I show Auto-Filter "Search" Criteria on Sheet1? | Excel Programming | |||
![Johnnyboy5[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
