Excel - How to Display Selected Slicer Value(s) in a Cell

A Slicer is used to apply a filter to a Pivot Table. It consists of a set of clickable buttons. But what if you want to display the text from the selected button or buttons and display it in a single cell?

This question has been asked several times recently in my Pivot Tables classes. In this video I show you my solution.

For full details see the timestamps below:

⏱ Timestamps
00:00:00 Introduction
00:01:14 Create a Pivot Table
00:01:53 Connect Pivot Table to the Slicer
00:03:03 Display Selected Item (Single) from the Slicer
00:04:14 Display all the Selected Items from the Slicer

🗒 Notes and Resources

The formulas that I used in the demos:
=Pivots!M3
=TEXTJOIN(", ",TRUE,M3:M20)
=Pivots!N2

✅ Want more FREE training?

🙋‍♂️ Let's connect on social

#excel #slicer #pivottable

[Crawf]

I've been trying to figure this out for ages, to make dynamic chart titles. Well done!

[vilnis_KP]

Fantastic! Thanks a lot!
Neither ChatGPT nor Gemini AI was able to give solution without VBA (which is restricted in our organization for security reasons).

[iziaurrahman]

Thanks MIke. Great video. It was very helpful.

[michaelhill]

When I go to report connection on the slicer tab it's greyed out and unable to click, even though I created a pivot table with my table. Any ideas?

[afeesakanni]

Thanks for this helpful tutorial. Please what of the default case where nothing is picked, and the slicer defaults to the first name? What if I want it to default to blank?

[shj]

thanks man, ilike your brief explanation, i have a sheet that have 2 slicers at excel, first one country second is division. what i want that if no slicer is selected data showing zero (grand total) not combine all slicers, hope you got my point

[RenierWessels]

Nice solution. Thanks Mike. I was thinking of a =TEXTJOIN(", ", TRUE, SORT(UNIQUE(table[field])))
Your solution is more simple and elegant though. Thanks for sharing!

[ayoolaolamiekan]

Thank you, very helpful. Quick question; is it possible to have the cell value show "All" when all values in the slicer are selected ? could we work around this with a formula?

[marcw.]

Thanks ! great stuff... what do you do when the new pivot tables have a valid name - but dont appear in the connections list ?
I made sure all Pivot tables are coming from same source...Table Name .

Thanks

[MatthewCraig-dk]

Can you display a slicer option without using pivot table. I use slicers in a table, but do I need to create the PivotTable?

[walterstevens]

Nice solution. But what if your slicer isn't on a pivot table but on an ordinary table?