I have an Excel worksheet that is an inventory list 17 columns wide.  I have Filtered the column headers (row eight) and I filter by various columns to generate different lists (I tried it with slicers, but they were more clunky for me to use).

I would like the header of the worksheet to change based on the filters applied.

I picture showing the filters in cells A1, A2, and A3, or perhaps in text boxes across a fat row 1.

Does anyone have a solution?

​I have an Excel worksheet that is an inventory list 17 columns wide.  I have Filtered the column headers (row eight) and I filter by various columns to generate different lists (I tried it with slicers, but they were more clunky for me to use). I would like the header of the worksheet to change based on the filters applied. I picture showing the filters in cells A1, A2, and A3, or perhaps in text boxes across a fat row 1. Does anyone have a solution?  Read More

​