View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
luvthavodka
 
Posts: n/a
Default 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.