Once you identify the database or list as a Table, Excel treats it as a single entity. This command identifies a database or list with headers and data as being a range of related cells. Excel 2007, Excel 2010, and Excel 2013 have a Table command that few know about.
Press the Alt + Q keys to close the Microsoft Visual Basic for Applications window dialog box. And you can add more slicers into the code or remove slicers from it as you need.
You can specify the position of slicers while scrolling the worksheet in the code. In the code, Column1 and Column2 are names of the slicers.
