Sorry, not sure what to call this one.
I inherited a decently complex spreadsheet (lots of macros and large number of calcs)
On one tab there are two columns that seem to work somewhat independently. They have a filter on them, and i can add a filter to columns to the right or to the left, but not both. I can turn off the filter on these two "independent" columns, but then the sheet does not allow me to highlight sections, including those columns, and apply a filter - it greys out the filter button as soon as i highlight into that area. How is this set up and controlled?
I inherited a decently complex spreadsheet (lots of macros and large number of calcs)
On one tab there are two columns that seem to work somewhat independently. They have a filter on them, and i can add a filter to columns to the right or to the left, but not both. I can turn off the filter on these two "independent" columns, but then the sheet does not allow me to highlight sections, including those columns, and apply a filter - it greys out the filter button as soon as i highlight into that area. How is this set up and controlled?