Forum Discussion
Excel Filter Not Working after Certain Row
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
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.
