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.