![]() ![]() Here are the basic steps that I explain in the video. The video above explains how to add the search box to the slicer. The solution will also work for the Mac 2016 version of Excel. Note: The filter search box was introduced in Excel 2010 for Windows, so this solution will work in the 2010, 2013, or 2016 versions for Windows. This solution uses the filter drop-down menu in another connected pivot table, and it is pretty easy to implement. The good news is that it does NOT require any macros or coding. So this solution is a bit of a workaround. Unfortunately there is no built-in way to add a search box to a slicer in Excel. How Can We Add a Search Box to the Slicer? She has a slicer with over 200 items (names) in it, and it takes a lot of time to scroll horizontally through the slicer to find a name. Kati asked a great question about adding a search box to a slicer. Add-a-Search-Box-to-a-Slicer-List-Selected-Items.zip Download Problem: It's Hard to Navigate Slicers with Lots of Items! ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |