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 “Slicer” button in the “Filters” button group to open the “Insert Slicer” dialog box. Then click the “Insert” tab in the Ribbon. 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. Insert Slicers and Delete Slicers in Excel: Instructions 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. Alternatively, to delete a slicer, right-click the slicer. Then press the “Del” or “Delete” key on your keyboard. To delete a slicer, click to select the slicer pane. To clear any filters applied, click the “Clear Filters” button in the upper-right corner of the slicer pane. 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 filter the associated object, click a field value button in the slicer to choose the value to display in the associated object. The slicer displays buttons that represent the unique field values from the selected field. To resize a slicer, click and drag the resizing handles that appear around the perimeter of the slicer. Then drag and drop the panel into a different location in the worksheet. To reposition a slicer in the worksheet, click and hold down the mouse button on an area without buttons in the slicer panel. Insert Slicers and Delete Slicers in Excel: A picture of a slicer applied to a PivotTable in Excel. Then click the “OK” button to add a slicer for the selected object into the worksheet. Click to place a checkmark in the checkbox next to the name of the field by which to filter the data with a slicer. 
This dialog box displays the field names within the associated tables of the selected object. Then click the “Slicer” button in the “Filters” button group to open the “Insert Slicer” dialog box. To insert a slicer into a worksheet, select one of these types of objects within a worksheet. In Excel, slicers visually filter data within Tables, PivotTables, PivotCharts, and Power Pivot tables and charts. You can easily insert slicers and delete slicers in Excel. Insert Slicers and Delete Slicers in Excel: Overview
0 kommentar(er)
