Now you should be able to click the filter drop-down button and use the Search box to quickly find items in the field (slicer) and apply filters. Hide the column that contains the field name in the Filters area of the new pivot table.(Right-click pivot table > PivotTable Options…) Turn off the Autofit column widths option on the new pivot table.Adjust the column width so the filter button is just to the right of the slicer.Move the slicer on top of the cell that contains the filter drop-down button in the Filters area of the new pivot table.Add the slicer field to the Filters area of the new pivot table.Remove all fields from the areas of the new pivot table.The slicer is connected to both pivot tables. The new pivot table will also be connected to the slicer.Make a copy of the pivot table and paste it next to the existing pivot table.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 |