autofiler disabled
 

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


--
yaronsh8
------------------------------------------------------------------------
yaronsh8's Profile: http://www.excelforum.com/member.php...o&userid=35317
View this thread: http://www.excelforum.com/showthread...hreadid=550948

autofiler disabled
 

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"
wrote in
message
...

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


--
yaronsh8
------------------------------------------------------------------------
yaronsh8's Profile:
http://www.excelforum.com/member.php...o&userid=35317
View this thread:
http://www.excelforum.com/showthread...hreadid=550948

autofiler disabled
 

the sheet is not protected.


--
yaronsh8
------------------------------------------------------------------------
yaronsh8's Profile: http://www.excelforum.com/member.php...o&userid=35317
View this thread: http://www.excelforum.com/showthread...hreadid=550948

autofiler disabled
 

Do you have more than one sheet selected?

Look for [Group] in the title bar

yaronsh8 wrote:

the sheet is not protected.

--
yaronsh8
------------------------------------------------------------------------
yaronsh8's Profile: http://www.excelforum.com/member.php...o&userid=35317
View this thread: http://www.excelforum.com/showthread...hreadid=550948

--

Dave Peterson

autofiler disabled
 

nope. only one sheet is selected...


--
yaronsh8
------------------------------------------------------------------------
yaronsh8's Profile: http://www.excelforum.com/member.php...o&userid=35317
View this thread: http://www.excelforum.com/showthread...hreadid=550948