![]() The Filter section has the Insert Slicer and Insert Timeline icons. When a PivotTable is selected, click the Analyze ribbon tab. Related: Learn how to use Excel PowerPivot A new addition in Excel 2013 is the Timeline Slicer, which handles date fields better than the standard Slicer. Slicers only work with PivotTables in Excel 2010, and the ability to use Slicers with formatted tables was added in Excel 2013. You need Excel 2010 or a later version to use Slicers. Slicers use buttons to allow you to select your filter items, and they display all the selected filter items. This is a graphic object that floats above the Excel grid. ![]() ![]() Is there a way around this?įiltering by multiple items in a PivotTable is best done with a Slicer. When I filter by more than one item in a PivotTable, it doesn’t display what those items are. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |