'Adding new data in excel and cannot be sorted or filtered
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:[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:[2]
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
Solution 3:[3]
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 4:[4]
I had this same problem, expanding the 'fill handle' as John Bustos (Nov 12 '12 at 17:29) suggested was all that I needed. I didn't have to turn filters off and on afterward either.
Solution 5:[5]
When you set up the Filter, it accounts for the range of data you initially have. When you add rows, they are outside of that range. So if you have one additional column that has something in it, like the word "blank" or just "X" or something, and make it go down to row 1000 or 2000 or something, then when you add information in new rows, it should keep the full filtered range, and the sorting would also include the full range, all the way to the row 1000 or 2000 or whatever you make.
Solution 6:[6]
As @JohnBustos suggested, the 'zebra' type row color is an outcome of choosing a certain condition in a pivot table.
When you add new rows to a table extracted from Pivot table, in order to include filter conditions/ sort for newly added rows, you need to -
- Go to far bottom right in row 595,
- you should have some kind of a fill handle,
- drag it down to now include your new rows too.
Solution 7:[7]
Make sure there isn't a space before the new data. That will sort in two batches.
Solution 8:[8]
There's a little handle at the bottom right corner of your table (as it exists)...drag this to the bottom of where your new data exists, and it should auto-expand the table to include the table design + filtering. Took me forever to figure out
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Aleem Devji |
| Solution 2 | user4106586 |
| Solution 3 | Nathaniel Ford |
| Solution 4 | Greg C |
| Solution 5 | MagicTK |
| Solution 6 | IlGala |
| Solution 7 | user14116442 |
| Solution 8 | Micah Smith |