Thread: How do I turn on Auto Filter?? It is grayed out.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default 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.

Reply With QuoteReply With Quote