Results 1 to 10 of 20

Thread: Printing Slicer Contents & Saving to .txt File

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Acolyte jdanniel's Avatar
    Join Date
    Jul 2018
    Posts
    63
    Articles
    0
    Excel Version
    2016

    Printing Slicer Contents & Saving to .txt File

    I'd like to print out the content of a slicer, or save its contents to a text file. Is this possible? Thank you!
    Last edited by AliGW; 2018-12-30 at 09:24 AM. Reason: New thread started.

  2. #2
    Acolyte jdanniel's Avatar
    Join Date
    Jul 2018
    Posts
    63
    Articles
    0
    Excel Version
    2016
    Still trying to figure this out. Google hasn't been as helpful with this one as I had hoped. Thank you!

  3. #3
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,274
    Articles
    0
    Excel Version
    Office 365 Subscription
    I'm afraid I'm not clear about what you are trying to do. What do you expect the contents of the text file to look like? And why do you need to do this, anyway?
    Ali
    Enthusiastic self-taught user of MS Excel!

  4. #4
    Acolyte jdanniel's Avatar
    Join Date
    Jul 2018
    Posts
    63
    Articles
    0
    Excel Version
    2016
    Ali,
    My spreadsheet has three slicers. One of them lists all of the "Artists" in the spreadsheet. (It's a music inventory spreadsheet. I also have a database for it, but I prefer spreadsheets.) Anyway, I figured it would be a lot easier to print out a list of artists via the slicer. That's all I want: A list of the artists. I know I could copy the Artists column to the Clipboard and paste it into Word. But I'd have to edit that list quite a bit.

    So what I'm really asking is: What is the absolute easiest way to print out a list of artists from this particular spreadsheet, without having duplicates in that list? I've done some reading on this, but honestly, being a novice, I'm a little bit fuzzy with the details.

    If the list has to be in table format, I can work with that. I can probably convert the table to text, and have what I'm looking for. Or, if Excel allows you to print out reports, similar to Access or FileMaker Pro, that would work, as long as there aren't duplicates.

    Which direction do you think I should be steered in?
    Attached Files Attached Files

  5. #5
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,274
    Articles
    0
    Excel Version
    Office 365 Subscription
    Copy and paste the column of artists’ names from the data table to a new worksheet, then, with the copied data still selected, click on the Remove Duplicates option on the Data ribbon. Once you have done this, sort the unique list alphabetically. Then just copy the list and paste it to wherever you want it. All done!
    Ali
    Enthusiastic self-taught user of MS Excel!

  6. #6
    Acolyte jdanniel's Avatar
    Join Date
    Jul 2018
    Posts
    63
    Articles
    0
    Excel Version
    2016
    TOO easy. TOO simple. Ali, Thank You!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •