How to Create a Slicer in an Excel Document
Open Microsoft Excel., Load the Excel data file you want to visually filter in a pivot table., Highlight the data., Select the PivotTable button. , Save your progress., Choose your data range., Check the boxes corresponding to the data sets you want...
Step-by-Step Guide
-
Step 1: Open Microsoft Excel.
This can be done by using the desktop icon, through the Start menu, or by using the Quick Launch taskbar, depending on your computer preferences. -
Step 2: Load the Excel data file you want to visually filter in a pivot table.
This can be done by clicking File in the upper left corner and then going to Open to select your data file. , You can highlight your data by either holding Ctrl+A or by left clicking with your mouse and dragging it over all the data. ,, Left click on the disk icon in the upper left corner of your Excel file to save your progress. , In this menu, you can also choose the location of your pivot table.
You can place it in an existing worksheet or create a new one. , You can check a single box or more than one. , Access the sorting options by clicking the table drop down menu , If you need to change the dimensions of your input range to accommodate more or less data you can find this from the “Options” ribbon under Change source data, you must select the table for this ribbon section to appear , You can then create a table to manage your data more easily.
Highlight all your data, select insert, and then left click on the Table on the upper left side of your Excel sheet , On the right side of the Excel sheet, you can select the data field(s) you want to create a slicer for by checking the box next to the field.
Then you right click on the field(s) you have chosen and click on Add as Slicer.
By default, all slices of data will be selected. , To look at a single slice of data, simply left click the slice of data you want to look at. , You can left click the multi-select button in Excel 2016 to select more than one slice of data.
In Excel 2013, simply hold Ctrl and left click on all the slices of data you want to look at. -
Step 3: Highlight the data.
-
Step 4: Select the PivotTable button.
-
Step 5: Save your progress.
-
Step 6: Choose your data range.
-
Step 7: Check the boxes corresponding to the data sets you want included.
-
Step 8: Pick your sorting options.
-
Step 9: Change your data source.
-
Step 10: Insert a table within your data.
-
Step 11: Right-click on pivot table field you want and choose “add as slicer”.
-
Step 12: Select a single slice of data.
-
Step 13: Select more than one slice of data.
Detailed Guide
This can be done by using the desktop icon, through the Start menu, or by using the Quick Launch taskbar, depending on your computer preferences.
This can be done by clicking File in the upper left corner and then going to Open to select your data file. , You can highlight your data by either holding Ctrl+A or by left clicking with your mouse and dragging it over all the data. ,, Left click on the disk icon in the upper left corner of your Excel file to save your progress. , In this menu, you can also choose the location of your pivot table.
You can place it in an existing worksheet or create a new one. , You can check a single box or more than one. , Access the sorting options by clicking the table drop down menu , If you need to change the dimensions of your input range to accommodate more or less data you can find this from the “Options” ribbon under Change source data, you must select the table for this ribbon section to appear , You can then create a table to manage your data more easily.
Highlight all your data, select insert, and then left click on the Table on the upper left side of your Excel sheet , On the right side of the Excel sheet, you can select the data field(s) you want to create a slicer for by checking the box next to the field.
Then you right click on the field(s) you have chosen and click on Add as Slicer.
By default, all slices of data will be selected. , To look at a single slice of data, simply left click the slice of data you want to look at. , You can left click the multi-select button in Excel 2016 to select more than one slice of data.
In Excel 2013, simply hold Ctrl and left click on all the slices of data you want to look at.
About the Author
Frances Ward
A passionate writer with expertise in organization topics. Loves sharing practical knowledge.
Rate This Guide
How helpful was this guide? Click to rate: