Forum Discussion
Filters as Worksheet Title
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?
- Did you intend to add images or (far better) to attach a copy of the workbook? That would help us help you a lot more than your verbal description.
- Sorry, this is my first post. I couldn't find how to add an attachment. How do I do that?
After you start to reply, click on "Open full text editor"...down toward the bottom of the section that is then presented you see a place where you can drag and drop a file. If that doesn't work for you, use OneDrive or GoogleDrive and paste a link here.
