Excel only filters first two rows

[kknapper]

Hi. I have a spreadsheet with about 20 columns that I need to be able to sort on. However, when I put a filter on the columns it is only recognizing the first two rows. For example I need to search on Country. The first two rows are USA and Canada (which are options in the filter), but the 3rd row is Spain and there are several others that aren't showing up in the filter. Does anyone know how I can fix this?

Thank you!

 

[Datsmart]

Welcome to the Board!

What version of Excel are you using?
Are there any blank rows in your table of Data?
How are you setting up the AutoFilter?

 

[kknapper]

Thanks for responding!

I don't have any blank rows and I'm using office 2007.

When I set up the filters I just click on the cell in the first row of the column and then go to Sort/Filter and click the filter button. As soon as I go to filter it all I see is the value for the first row. I thought it was the first two but it's only seeing the first row.

 

[VoG]

Click on the filter arrow and select the criteria to filter by.

 

[PGNCL]

Hi. I have a spreadsheet with about 20 columns that I need to be able to sort on. However, when I put a filter on the columns it is only recognizing the first two rows. For example I need to search on Country. The first two rows are USA and Canada (which are options in the filter), but the 3rd row is Spain and there are several others that aren't showing up in the filter. Does anyone know how I can fix this?

Thank you!

All these years later I am having exactly the same problem. If you ever got a solution and are still getting these messages I would be very grateful to know!

 

[PGNCL]

I have created a spreadsheet and want to filter to select certain rows, but when I apply the filter it only seems to list values from the first two rows, not all. What have I done wrong?

 

[RoryA]

Did you select all of the data before applying the filter?

 

[PGNCL]

Yes, tried that - though I wasn't clear why it was necessary. The filter down arrow appears OK, but the drop down list of choices doesn't include any in cells below the first couple of rows. Thanks for responding so promptly.

 

[RoryA]

It's to ensure that all the rows are included when you set up the filter initially.

Can you post a workbook somewhere - e.g. Dropbox or OneDrive - for me to have a look at?

 

[PGNCL]

Can I attach it to an email to you? That might test my IT skills less!