Forum Discussion
JLCantor
Jun 05, 2020Copper Contributor
Creating Slicers in Excel 2020 for Mac
I have created a small pivot table in the Excel for Mac 2020 version and would like to add slicers. Unfortunately the slicer button is greyed out no matter what cell I select within the pivot table....
Abiola1
Jun 05, 2020MVP
Hello,
To use the Slicer in Mac, you've got to select your data and click on Slicer from the contextual ribbon tab.
Do see the short video below to guide
https://youtube.com/watch?v=Vfk0H481X7w&t=1s
To use the Slicer in Mac, you've got to select your data and click on Slicer from the contextual ribbon tab.
Do see the short video below to guide
https://youtube.com/watch?v=Vfk0H481X7w&t=1s