![]() To make slicers start working for us, we would click any one of the items in a slicer to see how it instantly changes the table display.įor example, to see the nominees and winners in both categories for the year 2015, we would just click “2015” in the “Year” slicer. To use a slicer to filter the data in this table, we first need to remember that in their default state, the data in the table is displayed in an unfiltered format. Handle Bars: These eight handles allow you to resize or drag and drop the slicer as you would do with any graphic object.Scroll Bar: This indicates that there are more items available that will be visible by scrolling up or down.When grayed out, this means no filters have been applied. Clear Filter button: Click to remove all filters from the report.For earlier versions, hold down the Ctrl key while selecting multiple items within a slicer. Multi-Select button (Excel 2016 and later): Click this button to select more than one item at a time.Header: The slicer header indicates the pivot table field containing the values to be displayed or hidden.This can be done by using the handlebars to move or resize the slicer(s).įirst, we’ll do a walkthrough of what you can expect to see when working with slicers. ![]() ![]() Choose the category or categories that you want to be able to filter by.Īs a best practice, slicers should be placed in a location where updates to the pivot table can be immediately seen when slicer filters are applied.To insert a slicer, data must be stored in an Excel Table or a pivot table. The pivot table organizes the data nicely, but it is still a lot of information, which can make it difficult to find and extract the data we want. Let’s see what makes slicers so great by adding one to a pivot table that summarizes a six-year list of nominees and winners in two film categories.
0 Comments
Leave a Reply. |