| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lost Autofilter option
In EXCEL 2003 when I click on Data then Filter, I no longer see the
Autofilter choice. How do I get it back? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost Autofilter option
scrimmy;
Check to see that the worksheet is not protected. God Bless Frank Pytel http://groups.google.com/group/excel...et-programming "scrimmy" wrote: In EXCEL 2003 when I click on Data then Filter, I no longer see the Autofilter choice. How do I get it back? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost Autofilter option
You could try:
Tools|Customize|select the Standard toolbar and click the reset button. Any customized changes you've done to that toolbar will have to be redone. scrimmy wrote: In EXCEL 2003 when I click on Data then Filter, I no longer see the Autofilter choice. How do I get it back? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost Autofilter option
Dave,
Thanks for the repsonse. I tried your suggestion with no luck. When I click on the filter selection, the only choices I get a Show All(which is greyed out) and Advanced Filter. "Dave Peterson" wrote: You could try: Tools|Customize|select the Standard toolbar and click the reset button. Any customized changes you've done to that toolbar will have to be redone. scrimmy wrote: In EXCEL 2003 when I click on Data then Filter, I no longer see the Autofilter choice. How do I get it back? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost Autofilter option
You can reset all the toolbars.
Close excel Windows start button|Search look for *.xlb in hidden folders, too Rename them all to *.xlbOLD and restart excel to see if it helps. If it doesn't help, rename them back to *.xlb. If it does, delete those *.xlbOLD files and recreate any customized toolbars. scrimmy wrote: Dave, Thanks for the repsonse. I tried your suggestion with no luck. When I click on the filter selection, the only choices I get a Show All(which is greyed out) and Advanced Filter. "Dave Peterson" wrote: You could try: Tools|Customize|select the Standard toolbar and click the reset button. Any customized changes you've done to that toolbar will have to be redone. scrimmy wrote: In EXCEL 2003 when I click on Data then Filter, I no longer see the Autofilter choice. How do I get it back? -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lost Autofilter option
That took care of it. Thanks so much for your help!
"Dave Peterson" wrote: You can reset all the toolbars. Close excel Windows start button|Search look for *.xlb in hidden folders, too Rename them all to *.xlbOLD and restart excel to see if it helps. If it doesn't help, rename them back to *.xlb. If it does, delete those *.xlbOLD files and recreate any customized toolbars. scrimmy wrote: Dave, Thanks for the repsonse. I tried your suggestion with no luck. When I click on the filter selection, the only choices I get a Show All(which is greyed out) and Advanced Filter. "Dave Peterson" wrote: You could try: Tools|Customize|select the Standard toolbar and click the reset button. Any customized changes you've done to that toolbar will have to be redone. scrimmy wrote: In EXCEL 2003 when I click on Data then Filter, I no longer see the Autofilter choice. How do I get it back? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i have lost the File option on the top list on my excel spreadshe | Excel Discussion (Misc queries) | |||
| Lost Sage Integrated reporting option on toolbars | Excel Discussion (Misc queries) | |||
| lost option to insert comment, need it back? | Excel Worksheet Functions | |||
| Lost Record count when using Autofilter | Excel Discussion (Misc queries) | |||
| The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
Linear Mode
