View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default My autofilter is dimmed in one worksheet only in Excel 2003 ho

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.

LarrW wrote:
protection is not on

"ducky" wrote:



On Oct 9, 12:26 pm, LarrW wrote:

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 .


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

HTH

AR





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html