•From the slicer control panel on the left side, select Fiscal Year(s), Claim Type, Area Code, Dept. Code, Time, Cause, Nature, Body Part, Day of Week, Month, Tenure, and Age Range Learn more about Slicers •The tables and charts on the Agency Dashboard automatically update when the slicer buttons are selected or changed The Custom Number Format is a text string which tells Excel how you wish the number to be formatted. Custom number formats are separated into 4 sections, all separated by semicolons. [display of positive values] ; [display of negative values] ; [display of zero values] ; [display of text values].Nov 13, 2019 · Learn how to add a search box to a slicer to quickly filter your pivot tables, pivot charts, or Excel Tables. Includes a video tutorial that explains the setup in detail. 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.