My autofilter is dimmed in one worksheet only in Excel 2003 how d.

L

LarrW

I have a Excel 2003 file with multiple sheet and I am unable to autofilter,
it is dimmed and I have been unable to activate it .
 
D

ducky

I have a Excel 2003 file with multiple sheet and I am unable to autofilter,
it is dimmed and I have been unable to activate it .
Click to expand...

Sounds like your sheet is protected. You can unprotect it by clicking
tools>protection. if there is a password set, you'll need to have that
as well

HTH

AR
 
L

LarrW

protection is not on

ducky said:
Sounds like your sheet is protected. You can unprotect it by clicking
tools>protection. if there is a password set, you'll need to have that
as well

HTH

AR
Click to expand...
 
D

Debra Dalgleish

If you have more than one sheet selected, AutoFilter won't be available,
and [Group] will appear at the end of the file name in the Title Bar.
 
Top