Hello, I am working with Excel 2003 professional and just yesterday after entering a bunch of records to my file which has about 19,000 rows I discovered that my autofilter just stoped filtering completely. Since the release of Excel 2016 for Mac, customers have given great feedback about its ease of use and the benefits of the new features. To filter the PivotTable data, simply click one or more of the buttons in the slicer. Data Analysis ToolPak. Note that if a function key doesn’t work as you expect, then press the fn.
edwardaggie98
New Member
![My filter won My filter won](/uploads/1/2/6/2/126248434/439540168.png)
I searched this forum for this, but didn't find precisely this issue. I have a spreadsheet with around 415 rows and a few columns. Mostly text-filled, but some numbers. I'm trying to filter some of the text columns using the triangle buttons that appear in my top/header row.
When I click the header row button, I can see all the data in it. I'll select a value, and it will filter the data onto that value correctly - except for row 400 and beyond. Every row from 400 to the end of the rows appears and doesn't get filtered.
I've tried selecting that column and then filtering; this has no effect. Also, I have no blank cells in the range.
Ideas?
When I click the header row button, I can see all the data in it. I'll select a value, and it will filter the data onto that value correctly - except for row 400 and beyond. Every row from 400 to the end of the rows appears and doesn't get filtered.
I've tried selecting that column and then filtering; this has no effect. Also, I have no blank cells in the range.
Ideas?