Create a Slicer in a Table in Excel

 Create a Slicer in a normal Table in Excel is the smart way to create a filter! It can be used while using a Tab, Laptop or a Desktop!

 

 

In Excel, Slicers are an interactive way to filter data in PivotTables and Tables (Excel Tables). They provide buttons you can click to filter data, making filtering more intuitive than drop-down lists.

Steps to Create a Slicer in a Normal Table in Excel

1. Convert Data into an Excel Table

   • Select your data range.
   • Press Ctrl + T or go to Insert → Table.
   • Check the box "My table has headers" and click OK.

2. Insert a Slicer

   • Click anywhere inside the Table.
   • Go to Table Design (or Table Tools) → Insert Slicer.
   • Select the column(s) you want to filter with the Slicer and click OK.

3. Use the Slicer

   • Click the buttons in the Slicer to filter data instantly.
   • Hold Ctrl to select multiple items.
   • Use the Clear Filter button in the Slicer to reset the filter.

Why Use a Slicer?

• Provides a visual way to filter data.
• Works on Touchscreens, Laptops, and Desktops.
• Easier to use than drop-down filters.
• Allows multiple selections at once.

Now you can quickly filter and analyze your data using Slicers in Excel Tables!