Ready to Checkout?

shopping-cart

Try the Excel Course for Free!

Insert Slicers and Delete Slicers in Excel- Instructions

by / Friday, 22 September 2017 / Published in Excel 2013, Excel 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365

Insert Slicers and Delete Slicers in Excel: Overview

            This tutorial shows how to insert slicers and delete slicers in Excel. Within Excel, slicers visually filter data within Tables, PivotTables, PivotCharts, data visualizations in Power View, and Power Pivot tables and charts. To insert a slicer into a worksheet, with the exception of a data visualization in Power View, select one of these types of objects within a worksheet. Then click the “Insert” tab within the Ribbon. Then click the “Slicer” button within the “Filters” button group to open the “Insert Slicer” dialog box.

            This dialog box shows the field names within the associated tables of the selected object. Click to place a checkmark in the checkbox next to the name of the field by which to filter the data within a slicer. Then click the “OK” button to add a slicer for the selected object into the worksheet.

            To insert a slicer in a Power View sheet, click and drag a field from the “Power View Fields” task pane into the data visualization area. With the data visualization still selected, click the “Design” contextual tab that appears in the Ribbon. Then click the “Slicer” button in the “Slicer” button group.

Insert Slicers and Delete Slicers in Excel: A picture of a slicer applied to a PivotTable in Excel.

Insert Slicers and Delete Slicers in Excel: A picture of a slicer applied to a PivotTable in Excel.

            To reposition a slicer in the worksheet, click and drag the slicer panel to a different location within the worksheet. To resize a slicer, use the resizing handles that appear around the perimeter of the slicer. The slicer shows buttons that represent the unique values contained within the selected field.

            To filter the selected object, click the buttons within the slicer to choose the values to display within the associated object. The selected data object is then filtered by your slicer selection to only show records for the current button selection. You can use the multiple selection techniques of holding the “Shift” or “Ctrl” keys and then clicking multiple buttons within the slicer to select multiple adjacent or non-adjacent slicer buttons to filter for multiple values, if needed. To clear any applied slicer filters, click the “Clear Filters” button in the upper-right corner of the slicer pane.

            To delete a slicer, click the slicer pane to select it and then press the “Del” or “Delete” key on your keyboard. Alternatively, to delete a slicer, right-click the slicer pane. Then select the “Remove (field name)” command from the pop-up menu where the (field name) value is the name of the field used to slice the data.

Insert Slicers and Delete Slicers in Excel: Instructions

  1. To insert a slicer for a Table, PivotTable, PivotChart, or Power Pivot table or chart in a worksheet, select one of these objects.
  2. Then click the “Insert” tab within the Ribbon.
  3. Then click the “Slicer” button in the “Filters” button group to open the “Insert Slicer” dialog box.
  4. Check the checkbox next to the field name by which to filter the data.
  5. Then click the “OK” button.
  6. To insert a slicer in a Power View sheet, click and drag a field from the “Power View Fields” task pane into the data visualization area.
  7. With the data visualization still selected, click the “Design” contextual tab that appears in the Ribbon.
  8. Then click the “Slicer” button in the “Slicer” button group.
  9. To reposition a slicer in the worksheet, click and drag the slicer panel to a different place in the worksheet.
  10. If you want to resize a slicer, use the resizing handles that appear around the perimeter of the slicer.
  11. To filter the selected object, click the buttons within the slicer to choose the values to show within the object.
  12. You can use the multiple selection techniques of holding the “Shift” or “Ctrl” keys and then clicking multiple buttons in the slicer to select multiple adjacent or non-adjacent slicer buttons to filter for multiple values, if needed.
  13. To clear any filters applied, click the “Clear Filters” button in the upper-right corner of the slicer pane.
  14. To delete a slicer, select the slicer pane and then press the “Del” or “Delete” key on your keyboard.
  15. Alternatively, right-click the slicer and select the “Remove (field name)” command from the pop-up menu where (field name) is the name of the field used to slice the data.

Insert Slicers and Delete Slicers in Excel: Video Lesson

            The following video lesson, titled “Inserting and Deleting Slicers,” shows how to insert slicers and delete slicers in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2016-2013.”

TOP