#USING A SLICER IN EXCEL HOW TO#

See also How to Freeze Panes and Split in Excel

Click the Clear Filter button on the Year and Category slicers.

Notice that Excel displays all the products that fall under the category of fruit in the product slicers.

Move the Category slicer in line with the others.

The Insert Slicers dialog appears, click Category, then OK.

Now we can create a slicer out of another field.

Note you can also right-click on a slicer to access the Remove “Sales” option.

Press the Delete key, Excel removes the slicer.

Click the Sales slicer, the border gets darker around it.

This will allow you to make changes to the way that your slicer filters data. For example, if you want to change the fields you originally selected. Once you’ve created your slicer, it’s important to remember that you can always go back and edit it if necessary. A better practice is to create a slicer of all fields except the data field. Clicking on data fields will only return one record.

Including the data field (sales in this example) in slicers is not very useful.

Excel displays the record for that sales figure only.

Excel displays all records in the table.

Click the Clear Filter button in the Year and Product.

Whenever you select a field within a slicer, the Clear Filter icon becomes active.

Excel filters the table to the relevant cells.We want to see the apples sold in 2018:.We can use slicers to filter out individual items within each slicer. In our sample data, we have the sales figures from a grocery store. You can now use the slicers to filter the table data Excel filters the data in place. If the slicers are overlapping each other, use click and drag to separate them on the same row. From here, you’ll be able to choose which element you want to use as your slicer. Select the Year, Product, and Sales elements, then click OK. On the ribbon, click the Insert tab, Filters group, and click the Slicer button. Open the How To Use Slicers In Excel.xlsx file, Table. Click any cell within the Excel table. From there, you’ll be able to choose which element you want to use as your slicer. Refer to the sample data in the How To Use Slicers In Excel.xlsx file. To create a slicer in Excel, you first need to have some data that you want to filter. See also How to Use Text to Columns in Excel? Creating A Slicer from a Table This way, they can easily filter the data themselves without having to wade through everything.

#USING A SLICER IN EXCEL FULL#

Rather than sending someone an entire spreadsheet full of data, you can simply send them a file with the slicers already set up. Rather than having to manually filter your data each time you want to look at a certain subset, you can simply use a slicer and have the work done for you.Īnother benefit of using slicers is that they make it easy to share your data with others. Several benefits come from using slicers in Excel.įirst, they can save you a lot of time when filtering data. You can create slicers from tables or Pivot Tables in Excel. Simply click on the slicer element that you want to filter by and your data will be filtered accordingly.īest of all, slicers can be used on any type of data, whether it’s numerical or categorical. So, what exactly is a slicer? In short, slicers are interactive filters that allow you to quickly and easily filter data in Excel. Adding Slicers to a PivotTable – PivotTable Fields.Adding Slicers to a PivotTable – Ribbon.

Using a slicer in excel