Forum Discussion

scrail2004's avatar
scrail2004
Brass Contributor
Sep 30, 2024

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 slice...
Excel on Mac
mathetes's avatar
mathetes
Gold Contributor
Sep 30, 2024
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.
  • scrail2004's avatar
    scrail2004
    Brass Contributor
    Oct 01, 2024
    Sorry, this is my first post. I couldn't find how to add an attachment. How do I do that?
    • mathetes's avatar
      mathetes
      Gold Contributor
      Oct 01, 2024

      scrail2004 

       

      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.

       

      • scrail2004's avatar
        scrail2004
        Brass Contributor
        Oct 02, 2024

        mathetes Oh, full text editor is pretty slick.  But there is no window into which I can drop a file.  And I've never used OneDrive or GoogleDrive before.  The best I could figure out is to make the worksheet a jpeg file and paste it here (super-simplified version).  It's an inventory of teas.

         

        So if I filter the column headers and filter Type to show only Black teas, I'd like the title to read "Black".  Or if I filter Source to show only Mei Leaf teas, I'd like the title to read "Mei Leaf".  Or if I filter both of those, I'd like the title to read "Mei Leaf Black".