There is no setting to turn on or off.

See Debra Dalgleish's site for info and workarounds.

http://www.contextures.on.ca/xlautofilter02.html#Count


Gord Dibben MS Excel MVP

On Thu, 13 Dec 2007 10:45:02 -0800, Mike _Powell <Mike
wrote:

THere is a setting that indicates how many rows are returned when the filter
function is used. How do I turn that setting on ?