Auto Filter does not show all the data in the column
 

My worksheet that has 21 columns and 3007 rows. I have Auto Filters on all
but 2 of the columns. The Auto Filters work on all but 1 column.
Approximately 850 items are shown from the column which has 3007 unique
values.The range is the same for all the filters and no print range has been
set.

I've tried removing the filters from the other columns, and I continue to
get the same result.

Does anyone know what's going on here?

Please respond to my work email ). I had to sign on
using my personal email, but due to the firewall I cannot access it from work.

Thank you.

Auto Filter does not show all the data in the column
 

Hi Char

See
http://www.contextures.com/xlautofilter02.html#Limits

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Char" wrote in message ...
My worksheet that has 21 columns and 3007 rows. I have Auto Filters on all
but 2 of the columns. The Auto Filters work on all but 1 column.
Approximately 850 items are shown from the column which has 3007 unique
values.The range is the same for all the filters and no print range has been
set.

I've tried removing the filters from the other columns, and I continue to
get the same result.

Does anyone know what's going on here?

Please respond to my work email ). I had to sign on
using my personal email, but due to the firewall I cannot access it from work.

Thank you.

Auto Filter does not show all the data in the column
 

Thanks Ron!

That was just the info I needed!

"Ron de Bruin" wrote:

Hi Char

See
http://www.contextures.com/xlautofilter02.html#Limits

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Char" wrote in message ...
My worksheet that has 21 columns and 3007 rows. I have Auto Filters on all
but 2 of the columns. The Auto Filters work on all but 1 column.
Approximately 850 items are shown from the column which has 3007 unique
values.The range is the same for all the filters and no print range has been
set.

I've tried removing the filters from the other columns, and I continue to
get the same result.

Does anyone know what's going on here?

Please respond to my work email ). I had to sign on
using my personal email, but due to the firewall I cannot access it from work.

Thank you.