ExcelBanter - filter function, how many rows are returned setting in Excel.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - filter function, how many rows are returned setting in Excel. (https://www.excelbanter.com/excel-discussion-misc-queries/169567-filter-function-how-many-rows-returned-setting-excel.html)

Mike _Powell

filter function, how many rows are returned setting in Excel.

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

Gord Dibben

filter function, how many rows are returned setting in Excel.

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 ?

All times are GMT +1. The time now is 02:47 PM.