Autofilter,
When i use my autofilter it does not show all the data in the columns.
I have tried removing the filter and applying it again but it still does not work. I have about 4000 rows, does this matter? What am i doing wrong!!! Please help. |
Autofilter,
AutoFilter only displays 1000 items, look here for tips on ways round it,
http://www.contextures.com/xlautofilter02.html Regards, Alan. "Gem" wrote in message ... When i use my autofilter it does not show all the data in the columns. I have tried removing the filter and applying it again but it still does not work. I have about 4000 rows, does this matter? What am i doing wrong!!! Please help. |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com