![]() ![]() ![]() Select your table and on Insert Tab Click on Slicer command as shown below:Ī popup comes with all the fields listed based on the data source, here user to make choices on all the fields on which you want to put filter. Next we need to form slicers over given table. If you notice, all the headers at row 1 got auto filter and formatting of data gets changed, which reflects that you are moving into right direction. A popup will com to get user confirmation.Select your data including headers and navigate to Insert Ribbon Tab.In this article we will be referring slicers with List as data source. Slicers can be built over Table or Pivot, hence you need to convert your data into a data source. To provide advanced level of filters and good visual over the data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |