May 31 2023 07:54 AM
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 data daily. However, when I try to filter it will only apply the filter up to a certain row. I have no blank rows or merged cells. I tried going to the "advanced" option for filter and putting the range up to a certain row but that didn't work. I have also tried to select the data to turn the filter off then on, but when I select the data is greys out the filter button where I cannot do that.
Any input and help would be greatly appreciated!
May 31 2023 08:01 AM
Solution@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
May 31 2023 08:04 AM
May 31 2023 08:08 AM
May 17 2024 01:36 PM
@jbabineaux92 This was super helpful! thanks so much!!
Jul 30 2024 05:01 PM
That worked great, thank you! @mtarler
May 31 2023 08:01 AM
Solution@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