Forum Discussion
VF_17
Oct 16, 2020Copper Contributor
Slicers not appearing for Excel Online
Hi all I downloaded an Excel spreadsheet from a course I am taking online. I created a pivot table and chart as instructed by the instructor. The next step is to add slicers. I am not seeing the ...
SergeiBaklan
Oct 17, 2020Diamond Contributor
Interface for working with PivotTable in Excel Online is slightly different from desktop version.
If you stay on PivotTable, this tab on ribbon shall appear
as well as right pane. If you hover the mouse on the field in right pane it will show that drop-down menu exists, click on arrow down at the right and from here you may add slicer
In addition, if you click Settings icon under PivotTable on ribbon, another right pane appears where you could play with PivotTable settings
Please note so far you can't add slicer for the Table in Excel Online, only for the PivotTable. Most probably this icon for Table you see on ribbon as greyed out. Forget about it for now, it do nothing.