Limit excel slicer to one selection

preview_player
Показать описание
An example of an Excel slicer allowing only one user selection. No VBA.
Рекомендации по теме
Комментарии
Автор

Select slicer settings and uncheck "Display Header" option. - hope this helps.

fionamehta
Автор

Does not stop Ctrl selection, sorry. - really only alerts a user to select 1 category - handle with care!

fionamehta
Автор

Hi, i am using EXCEL 2013 and on the slicer properties I cannot see "Multi-Select User control".  Does this only apply on version 2016 or higher ?

etienneyeekit