Page 1 of 2 1 2 LastLast
Results 1 to 10 of 20

Thread: Printing Slicer Contents & Saving to .txt File

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

    Printing Slicer Contents & Saving to .txt File



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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 08: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,252
    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,252
    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!

  7. #7
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,252
    Articles
    0
    Excel Version
    Office 365 Subscription
    That's often the way! You're welcome.
    Ali
    Enthusiastic self-taught user of MS Excel!

  8. #8
    Acolyte jdanniel's Avatar
    Join Date
    Jul 2018
    Posts
    63
    Articles
    0
    Excel Version
    2016
    Ali,
    I have a follow-up question, if you don't mind my asking it.

    When I select Column A and copy it to the Clipboard, it includes all of the blank cells below the last cell that has data in it.

    So, if I paste the text in that column into Word or Word Pad or Notepad, I have seemingly endless pages of blank space that I have to delete. I don't yet know of any easy way to delete all that blank material.

    I know one workaround to this problem: I can simply select ONLY the cells in Column A that have data. That's easy, and it works, but it's a little time-consuming. Not a huge time waster, but it's something I'd rather not do. Eventually, I'll have a few hundred artists in that column. That will make selecting that column more time-consuming than it is now.

    So…my question is: Is there a way to select the data in Column A without including all of the blank cells at the end? Thanks again! Jd
    Attached Files Attached Files

  9. #9
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,252
    Articles
    0
    Excel Version
    Office 365 Subscription
    When you have removed duplicates, select just the cells that are left after sorting and paste those across. You are making this more difficult than it needs to be, honestly!
    Ali
    Enthusiastic self-taught user of MS Excel!

  10. #10
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,252
    Articles
    0
    Excel Version
    Office 365 Subscription
    Here's a way to generate the list using Power Query - this is set to refresh every minute, so all you have to do is copy and paste from this list to your other documents.
    Attached Files Attached Files
    Ali
    Enthusiastic self-taught user of MS Excel!

Page 1 of 2 1 2 LastLast

Posting Permissions

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