How To Add A Search Box To A Slicer In Excel - Learn How In This Quick Tutorial!

Learn how to add a search box to a slicer to quickly filter pivot tables, pivot charts, or Excel Tables.

Here are basic instructions from the video.

The blog post page contains more screenshots and keyboard shortcuts for the filter search boxes.

1. Insert a slicer on the worksheet.
2. Make a copy of the pivot table and paste it next to the existing pivot table.
3. The new pivot table will also be connected to the slicer. The slicer is connected to both pivot tables.
4. Remove all fields from the areas of the new pivot table.
5. Add the slicer field to the Filters area of the new pivot table.
6. Move the slicer on top of the cell that contains the filter drop-down button in the Filters area of the new pivot table.
7. Adjust the column width so the filter button is just to the right of the slicer.
8. Turn off the Autofit column widths option on the new pivot table. (Right-click pivot table, PivotTable Options…)
9. Hide the column that contains the field name in the Filters area of the new pivot table.

[lisasoulet]

I hope you are still making tutorials for Excel. The ones I have watched so far about pivot tables have been very helpful and easy to understand!

[rickb.]

Thanks Jon! I wanted an easy date select drop down and this inspired me to use the pivot version\search for the user. I created a data dashboard already with multiple criteria based on the date selection and this helped.


Excel is so underrated :) . Like being able to to sum multiple values based on multiple criteria with a simple sumifs ...


Thanks for your videos!

[anestis]

Thank you, Jon. I've been using your videos and tutorials for a while now and always find them helpful and easy to follow. Thank you very much for the work you do!

[terriemarieferguson]

Thanks Jon! I am an accounting student and need to do projects with reports and I am going all out to adding a dashboard on the main page! I have always wanted to know how this is done and now I can do it also!

Thank you again!
Terrie Marie

[kimkamkun]

love watching your excel tutorials. I am currently having a test as data analyst and I need to get exposed with excel and dashboard and everything so your videos really helped me alot building my dashboard from scratch and the connection of slicer is really a gold mine lol more power to you sir

[sriramvaradarajan]

Outstanding tutorial! Loved the extra detail around making this "slicer filter" look super elegant. Kudos!

[mirrrvelll]

Always simple and straight to the point! Great!!

[jesuspalalia]

Thanks John! I really appreciate your videos. Very helpful.. I've also purchased your Paste Buddy tool 2 years ago. Fasciltated my job big time. Much appreciated.

[mikeflanagan]

outstanding trick - I'm new to slicers and this is great

[SimpleBk]

Very clever trick. Thanks for sharing your knowledge and expertise Jon

[usmanrahim]

This put a smile on my face and I subscribed immediately.

[erniecamerino]

Jon, this is so helpful!! I really appreciate how you teach.

[fraellynllena]

Always love your videos jon! Gets me excited everyday to get things done! ❤️❤️👌

[wmcnabb]

I love people that love Excel and learn something new everyday from them. Amazing how something so simple is the most awesome solution to a problem I have encountered many times. Thank you Jon.

[miguelcastillo]

I enjoy, and find it very easy to follow your instructions. Thank you for your time and work.

[mehdihammadi]

Very interesting as always. Thank you for sharing Jon.

[traceylu]

It is so great Jon. Thank you so much, exactly what I am looking for.

[johnsonpioneer]

Very lovely technique, this will save me a lot of time for large reports. Thank You.

[ranjthk]

Your !dea was excellent !!.. hope this is one of the corrections or value additions in the upcoming versions of excel. Thanks!..

[database_tips_tricks]

wow what would we do without this channel THANK YOU your "tricks" are so helpful for any business