How do I turn on Auto Filter?? It is grayed out.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Sheet is Protected?

You have two or more sheets selected(grouped)?

Either of these will prevent Autofiltering.


Gord Dibben MS Excel MVP
 
I have unprotected my worksheet and still have the auto filter option greyed.
How else can I activate the auto filter.
 
How about the multiple sheets selected?

Did you check for that?

I have no other ideas right now.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Filter Option grayed out 13
Auto-filter not grabbing all the data 2
Turning Off an Advanced Filter 1
Error in formula after auto-filtered 2
Auto filter on blank lines 1
Data - Filter - Auto Filter 1
Auto filter for multiple columns 2
VBA: How can I use a string variable as autofilter criteria? 4

Back
Top