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.

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.

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 <[email protected]> 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.