Adding new data in excel and cannot be sorted or filtered

Question

I have a column with 595 rows. Then I proceeded to add 20.

(Note this excel sheet with the 595 entries was already in place before I started working on it. The sort feature was working correctly, as was the filter feature).

So now, I can still USE the sort and filter methods, but it does not take into account these 20 new rows. Any ideas?

Also, I cannot remove the borders on these 20 new rows. They are pretty thick and say I just did 'no borders', it doesn't modify anything.

It seems like there's a 'cutoff' at 595 or something. Very weird.

Solution 1

Another solution which may not be as obvious is to Un-click the filter button under the data tab and then re-click filter.

Solution 2

I had the same problem using an absence tracker downloaded Excel worksheet from Microsoft, where I added 30 rows. I fixed the problem by clicking/activating the table and viewing the design tab. Click Resize Table and edit the table range. This color coded the rows and allowed the filter to include the added rows.

Solution 3

I had the same problem. After 45 minutes of experimenting and 'googling' for solutions it turned out that the new names I had entered did not have a space in front of them like ALL the other names in that column did. So check to see if the data in the columns are the same distance from the cell wall. If they are different, try adding or removing a space and re-sort. Good Luck