Insert Slicers and Delete Slicers in Excel- Instructions

Insert Slicers and Delete Slicers in Excel: Video Lesson

            This 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.2019 and 365.”

Insert Slicers and Delete Slicers in Excel: Overview

            You can easily insert slicers and delete slicers in Excel. In Excel, slicers visually filter data within Tables, PivotTables, PivotCharts, and Power Pivot tables and charts. To insert a slicer into a worksheet, select one of these types of objects within a worksheet. Then click “Insert” tab in the Ribbon. Then click the “Slicer” button in the “Filters” button group to open the “Insert Slicer” dialog box.

            This dialog box displays 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 with a slicer. Then click the “OK” button to add a slicer for the selected object into the worksheet.

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 hold down the mouse button on an area without buttons in the slicer panel. Then drag and drop the panel into a different location in the worksheet. To resize a slicer, click and drag the resizing handles that appear around the perimeter of the slicer.

            The slicer displays buttons that represent the unique field values from the selected field. To filter the associated object, click a field value button in the slicer to choose the value to display in the associated object. If you want to select multiple choices in the slicer to filter for multiple values, use the multiple selection techniques of either holding the “Shift” or “Ctrl” keys and then clicking multiple buttons in the slicer to select either multiple adjacent or non-adjacent slicer buttons. To clear any filters applied, click the “Clear Filters” button in the upper-right corner of the slicer pane.

            To delete a slicer, click to select the slicer pane. Then press the “Del” or “Delete” key on your keyboard. Alternatively, to delete a slicer, right-click the slicer. 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 within a worksheet, select one of these types of objects in a worksheet.
2. Then click the “Insert” tab in the Ribbon.
3. Then click the “Slicer” button in the “Filters” button group to open the “Insert Slicer” dialog box.
4. Click to place a checkmark in the checkbox next to the name of the field by which to filter the data with a slicer.
5. Then click the “OK” button.
6. To reposition a slicer in the worksheet, click and hold down the mouse button on an area without buttons in the slicer panel.
7. Then drag and drop the panel into a different location in the worksheet.
8. To resize a slicer, click and drag the resizing handles that appear around the perimeter of the slicer.
9. To filter the associated object, click a field value button within the slicer to choose the value to display in the associated object.
10. If you want to select multiple choices in the slicer to filter for multiple values, use the multiple selection techniques of either holding the “Shift” or “Ctrl” keys and then clicking multiple buttons in the slicer to select either multiple adjacent or non-adjacent slicer buttons.
11. To clear any filters applied, click the “Clear Filters” button in the upper-right corner of the slicer pane.
12. To delete a slicer, click to select the slicer pane and then press the “Del” or “Delete” key on your keyboard.
13. Alternatively, to delete a slicer, right-click the slicer.
14. 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.