Filter by Slicer

 



🧾 Objective:

To filter a data table in Excel using a Slicer, and format it for easy and visual filtering by options like Market (e.g., Delhi, Goa, etc.)

✅ Step-by-Step Process Flow

🟩 Step 1: Prepare the Data Table

📌 Action:

  • Select the entire dataset including headers.

📌 Example from Image:

Select from:

A1:E14
(Market, City Code, Date, Product Name, Sales QTY)

🛠 Convert to Table:

  • Press Ctrl + T

  • Ensure "My table has headers" is checked.

  • Click OK

Now, your data is in Excel Table format, which enables advanced features like slicers.

🟦 Step 2: Insert a Slicer

📌 Action:

  • Go to the Insert tab in the Ribbon.

  • In the Filters group, click Slicer.

  • A dialog box appears with all table column names.

✅ Choose the Column for Filtering:

  • Select “Market” (as shown in your image).

  • Click OK

🖼️ A slicer object now appears with buttons for each market (e.g., ABC, Andhra, Delhi, Goa).

🟧 Step 3: Format the Slicer

🔄 Right-click the Slicer

  • Choose Size and Properties or Size and Layout from the menu.

🧮 Adjust Columns:

  • In the right-side panel or layout options, change Number of Columns to e.g., 4

  • This arranges slicer buttons side-by-side as shown (ABC, Andhra, Delhi, Goa).

↔️ Resize Slicer:

  • Drag the corners or input exact width/height to fit your layout.

  • You can also:

    • Change colors from Slicer Tools → Options

    • Enable multiple selections

🧪 Example Outcome (As Per Image):

When “Delhi” is selected in the slicer:

  • The data table below automatically filters to only show rows where Market = Delhi.

  • All other rows are hidden.

  • You can click other markets to change the view instantly.

🎯 Benefits of Using Slicers:

  • Visual and intuitive filtering.

  • Works dynamically with Excel Tables and PivotTables.

  • Customizable layout and styling.

🔄 To Remove Filter:

  • Press the Clear Filter icon (top right corner of slicer box).

Sample Picture:


Another Sample Video: