Learn Excel – Hide Excel Columns with Slicer – Podcast 1796




About this tutorial:

Video duration: 4:45
Dalia tried to use the Excel Interactive View to show data on the web, but she needs to show/hide columns instead of rows. Today, a way to filter by column using two pivot tables and a slicer. To try out the web app:

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

9 thoughts on “Learn Excel – Hide Excel Columns with Slicer – Podcast 1796

    kosh2600

    (August 12, 2018 - 8:40 am)

    Hi I have a more advanced problem if you can help. I have the following columns: Date, year, Store, Sales, QuantitySold, Transactions. The store sales, transactions and qty sold are per day and I create a pivot table in order to consolidate them per year. I would like to create a pivot chart from that data but I would like to be able to use a slicer and filter whether I am viewing the total Sales, the total sold qty, total transactions or the three of them together. Do you know if this is possible?

    Dalia Ziausiene

    (August 12, 2018 - 8:40 am)

    It worked! Thanks again!
    And… the last question 🙂 Is it possible to insert hyperlink in the pivot table?

    Luciano Moreira

    (August 12, 2018 - 8:40 am)

    Muito bom, obrigado..Mr.Excel..

    Dalia Ziausiene

    (August 12, 2018 - 8:40 am)

    I have another question. How I should create and modify Pivot Table for making clicer as You recommended, if I have a table like this one and want to add slicers not only for year, but also for columns of group and indicator and so on.

    Group Indicator Year
    2010 2011 2012
    Population Total
    Population Male
    Population Female
    Mortality Total
    Mortality Male
    Mortality Female

    ExcelIsFun

    (August 12, 2018 - 8:40 am)

    That is amazingly clever! What a great way to start my Monday!!!

    Excel On Fire

    (August 12, 2018 - 8:40 am)

    Bill, thanks for answering Dalia's questions, and thanks for the shout out!
    This is what makes the Excel community great. 🙂

    Excel On Fire

    (August 12, 2018 - 8:40 am)

    Dalia, thanks for asking the question!

    Dalia Ziausiene

    (August 12, 2018 - 8:40 am)

    Excellent! That is what I am looking for! Thanks!

    James Tays

    (August 12, 2018 - 8:40 am)

    Great video Bill!

Leave a Reply

Your email address will not be published. Required fields are marked *