Filtering options are not available.

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

Guest

My filtering options are locked.I try to click on the filter arrow in one of
my cells, and I cannot selet anything. When I go to DATA, then FILTER, AUTO
FILTER is checked but I am unable to change anything. The FILTER options are
grayed out. How do I fix this?

Thanks
 
The sheet might be protected - click on Tools | Protection and if it
is protected then you will see the option Unprotect sheet. You may
need to supply a password to unprotect it.

Hope this helps.

Pete
 
Perhaps the worksheet is protected under Tools>Protection>Protect Sheet?

Perhaps you have more than one sheet selected?


Gord Dibben MS Excel MVP
 
Back
Top