How to Add a Search Box to a Slicer in Excel - while using Tables

Occasional Contributor

Hi all,


I wish to create a slicer on the visualization with a search box. However, as I do not want the data to be summarised, I have imported my data as a Table instead of a Pivot Table (which means I am unable to duplicate the Table, report connections etc). This has resulted in me not being able to re-create what the tutorial below has shown me.


I have referred to the video below prior: 


Does anyone have any idea how I can add a search box to a slicer while using Tables?

Thank you in advance. 

Learn how to add a search box to a slicer to quickly filter pivot tables, pivot charts, or Excel Tables.Click here to download the files: http://www.excelcam...
4 Replies


Take a look here, maybe this information will help you. It's just a suggestion, if that's not what you have in mind, please just ignore it.


Add worksheet data to a Data Model using a linked table


Wish you a nice day.



I know I don't know anything (Socrates)


This trick works only with PivotTable, not sure that something similar could be done for Tables.

Hi Nikolino,

I've looked at the document but that wasn't really what I was looking for. Thank you for contributing still.
Hi Sergei,

Thank you for your comment. I can't seem to do that after messing around with various functions.