Tables are a useful feature in Excel for Data processing. You can convert a range of cells into an Excel table to make managing and analyzing a collection of linked data more accessible. Excel provides some simple methods for converting a range to a table.
Before adding a slicer to filter the data in excel, you need to convert the data range into a table.
Converting a range to a table
-
Select your data range
-
Go to Insert >> Press Table – to popup Create Table dialog box
-
Make sure My table has headers checkbox is checked and press “OK”
Now your table is ready to add the slicer -
Insert 5 rows and 3 columns - give sufficient space on the left and top of your table
-
Click any cell in your table
-
Go to Table Design >> Press Insert Slicer – to popup Insert Slicers Dialog box
-
Check “Product” and Press “OK” to add the Product slicer to your excel sheet
-
Adjust your slicer (Product Slicer) height and width to fit your screen
-
Select any item in the slicer you can see the filtered data in your table
