Forum Discussion
Filter not capturing all content
It could be a blank row within the data set. If you don't specify the range when applying the filter Excel will presume the 'current region' (If you're active within the data and press ctrl+a you can see what's being considered part of the current region. These rows will be considered by the filter).
If there are blanks in the data set, you can remove the filter, make a point to select all your data (header included) and then apply the filter. Sorting works on the same principle.
It's a bit difficult to diagnose with any certainty with your brief description. For example, we don't know the layout of the screen, only that when you click on the little filter carat (an assumption) you see the choices of NY, CA, TX, but those could come from the top three rows alone. You're assuming A6 has been included, but it needn't be. Are the top three rows designated as a table, with the rows beneath not included (all this perhaps inadvertent). If you highlight all the rows, including A6 and beyond, what happens?
Perhaps you could fill in some of the gaps in your description.