| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto filter is greyed out
Hi, for some reason one of my work books is suddenly refusing to let me
use autofilter on all of my worksheets within the book - the option is greyed out. It is also refusing to allow me to use the trace precedents and trace dependents functions, it is almost as if the option has been "turned off" by accident, but I dont know how to turn it back on. I would really appreciate any suggestions, I have tried looking at the trouble shooting guide in microsoft but it doesnt really help.... HELP!!!!! Many thanks in advance Laura |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto filter is greyed out
By the way, my work book is not protected (it seems) and also I dont have more than one sheet selected (it seems) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto filter is greyed out
Laura wrote: By the way, my work book is not protected (it seems) and also I dont have more than one sheet selected (it seems) Hello, to anyone that is intersted, I worked out the answer I managed to reinstate my auto filter by going to tools/options/view and selected to view all objects. Who knows why it was turned off, but nevermind, it works now! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn on Auto Filter?? It is grayed out. | Excel Discussion (Misc queries) | |||
| Is there a way to link Auto Filter values to a Cell | Excel Worksheet Functions | |||
| Auto Filter - Protected sheet/workbook | Excel Discussion (Misc queries) | |||
| auto filter question | Excel Worksheet Functions | |||
| Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions | |||
Linear Mode
