If I were using filters in a data table is there any way that I can show what filters are being used, without clicking on the filter? Is it possible to have a cell reference the filters and show users of the workbook what filters are selected?
You'll notice that where filters are applied, the arrow in the filter is in blue. That indicates that a field has an active filter. As to see what the exact filter is, no idea. I'm pretty sure it's a 'dumb' filter---IE you can't reference a cell or anything.