But inserting a slicer into your table makes the report more user-friendly. I am sure you have also experienced this in your daily work. When we apply the pivot table, which has many fields, it often failed to convey the correct message due to too many fields in it. Note: Download the workbook to follow me. Don’t be overwhelmed by the cool feature of Slicer because I have a lot more in it to reveal many things. I am sure you are smiling at the beautiful option of Slicers and its cool features. #2 How to Insert a Slicer to Your Pivot Table? Now I have selected the country name Canada and data table showing only Canada country’s data. If you click on a specific country data table will display only the selected country’s data. It will list out all the unique values from the list. This is the slicer I have inserted for the heading Country. But I have selected the COUNTRY column heading only. Note: You can select all the headings as well. Select the required column you want to filter out the data quite often.It will show you all the available headings in the table. Under this tab, you can see the Slicers option (Only from excel 2013 onwards). As soon as the table has been created, you will see a new tab in the ribbon called Design.Click on OK it will create a table for you.Select the entire data and press Ctrl + T to add a table to the data range.Below are the steps to insert slicer to your regular excel table –
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |