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.

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.

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.

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.

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.