autofiler disabled

[yaronsh8]

Hi everyone!
i recently discovered the wonderful autofilter option. however, for
some reson, in some sheets this option is disabled. i wish to know what
cause it to be disabled in some sheets and enabled in others?
thanks,
yaron

 

[Chip Pearson]

If the sheet is protected, you can't use autofilter. Unprotect
the sheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"yaronsh8"
message
news:[email protected]...

 

[yaronsh8]

the sheet is not protected

 

[Dave Peterson]

Do you have more than one sheet selected?

Look for [Group] in the title bar

 

[yaronsh8]

nope. only one sheet is selected..