Force Excel Slicers to Single Select Using These Crafty Tricks

There's no built in way to force Excel Slicers to single select. However, in this video I'll show you a couple of ways your users won't be able to ignore your requests for them to only select one item in a Slicer.

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

💬 Please leave me a COMMENT. I read them all!

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

[kissxk]

I love watching your videos as there are always snippets of productive techniques demonstrated that boosts our creativity. Great way to get the best out of pivot features and and regular graphs.

[pravinshingadia]

Thank you for this. You really are amazing and always seem to produce videos that people need to know!

[longland]

You can overlay a shape that covers the title and the multi select just leaving the X showing. Lock it all down and protect the sheet. A side benefit is you can use the shape to give the headers of your slicers a unique and consistent style and add text back in for the title of you need it.

[pickleball]

This is fantastic! Thanks for sharing! One thing, at the end when showing the other way to display a message in red, you say you can't hide the line, but you showed us exactly how to do that earlier in the video by multiplying the sum of sales value in the dummy pivot table by the Isblank() function (Boolean value or 0 or 1). I tried that and it worked great. Thanks so much for doing this!

[donc]

Absolutely AWESOME TIPS!!! I haven’t been paying attention to the Excel upgrades…Holy cow, we’ve come a long way since Lotus123

[anillpatel]

Excellent examples. Very useful. Thank you Mynda.

[mattschoular]

Thanks Mynda. Those are helpful tricks.

[vijayarjunwadkar]

Very nice idea Mynda! You find innovative ways to workaround practical challenges and present them for viewers to easily understand. Thank you! 😊👍

[Acheiropoietos]

I knew some of these tricks but all of them. Impressive!

[IvanCortinas_ES]

Excellent trick Mynda. Thank you so much for sharing.

[johnborg]

Thanks Mynda. This is very Helpful to me. Thanks Again. :) :)

[navisalomi]

Fantastic tricks and tips as always. Thanks immeasurably.

[jayasam]

Hey thank you so much I was looking for this trick from such a long time..it is indeed help...👍

[heikoheimrath]

Nice tips Mynda - have a great weekend

[s.y.daniel]

Good tricks. Never thought about such possibility

[wayneedmondson]

Hi Mynda. Great tips and techniques for solving this problem. Thanks for sharing :)) Thumbs up!!

[ricos]

Excellent video. I use Power Pivot quite a lot and hate having to deal with this issue. Obviously, it's simple enough to amend a measure to return blank based on HASONEFILTER(), but when you have many slicers, it becomes annoying. It always surprises me how/why the Excel team created such an obvious and great feature in the slicer, but didn't think through the very basic use cases of a slicer. It's effectively a fancy looking list box, and when you go into the properties window of a list box in VBA, you have the very simple property "multi select", which can be set to single or multiple (or extended). When creating the slicer, it's like they didn't do a business case for it!

Don't get me started on the Timeline filter either! That thing is awful.

[jackennis]

Hi Mynda, excellent video! I eagerly await your videos every week. I love all of your tips and tricks. Your knowledge of Excel is truly phenomenal :)

[davidcarrico]

Thank you for all the great videos. Would love to see videos on scripting macro replacements that work across excel online and excel desktop.

[excel-businessinexcel]

Спасибо за вашу работу! Стараюсь всегда вас смотреть.