| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I turn on Auto Filter?? It is grayed out.
I would like to filter on the various items listed in a column, but when I go
to filter, the Auto Filter is grayed out. I have used Auto Filter on other spreadsheets, but this one I can't get it to be available. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I turn on Auto Filter?? It is grayed out.
The sheet must be protected. Go to Tools/Protection/Unprotect Sheet. Try it
first without a password. This should then allow you to use filter. If a password is required the person who created the spreadsheet would have to inform you of this. "Ray" wrote: I would like to filter on the various items listed in a column, but when I go to filter, the Auto Filter is grayed out. I have used Auto Filter on other spreadsheets, but this one I can't get it to be available. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I turn on Auto Filter?? It is grayed out.
Ray
Sheet is Protected? You have two or more sheets selected(grouped)? Either of these will prevent Autofiltering. Gord Dibben MS Excel MVP On Fri, 16 Jun 2006 12:23:02 -0700, Ray wrote: I would like to filter on the various items listed in a column, but when I go to filter, the Auto Filter is grayed out. I have used Auto Filter on other spreadsheets, but this one I can't get it to be available. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I turn on Auto Filter?? It is grayed out.
I have unprotected my worksheet and still have the auto filter option greyed.
How else can I activate the auto filter. -- judy "Gord Dibben" wrote: Ray Sheet is Protected? You have two or more sheets selected(grouped)? Either of these will prevent Autofiltering. Gord Dibben MS Excel MVP On Fri, 16 Jun 2006 12:23:02 -0700, Ray wrote: I would like to filter on the various items listed in a column, but when I go to filter, the Auto Filter is grayed out. I have used Auto Filter on other spreadsheets, but this one I can't get it to be available. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I turn on Auto Filter?? It is grayed out.
How about the multiple sheets selected?
Did you check for that? I have no other ideas right now. Gord On Wed, 18 Mar 2009 09:56:34 -0700, judy wrote: I have unprotected my worksheet and still have the auto filter option greyed. How else can I activate the auto filter. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| The Auto Filter button lost the column specified option. | Excel Worksheet Functions | |||
| Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions | |||
Linear Mode
