Forum Discussion
Solved
Excel Filter Not Working after Certain Row
Help! I have been trying all the tips online that I've found and nothing seems to work. I have a spreadsheet with a large amount of data and I have my columns filtered. I am continuously adding ...
jbabineaux92 Is it possible the upper part is a defined table and the data below is not included in that table like this:
You can check the Name Manager to see if a table is defined for that range. If so when you click on any cell in that range you will get a "Table Design" menu item in the menu bar. And then on the left you can select "Resize Table" to include the additional data
Oh wow!! This was not something I was aware of but it fixed my problem! Thank you so much!
Tables are VERY useful and I recommend you learn about. Especially good for table references. i.e. you can name the table like "Data" and then refer to a column of data like "Cost" using Data[Cost] which not only means something when you see it instead of Sheet3!$D:$D but also refers to ONLY the range of data in that table instead of the whole column. you can also link tables and other things too.