Thread: Mandatory Selections in AutoFilter

Hi all

Is it possible to make some selection mandatory on an autofilter?
In my sheets its possible to filter by value 1, 2, 3, 4
1, 2, 4 are mandatory selections - the only deselectable items should be 3.

I've tried googling this - but havent found anything.

Hi DILIPandey

Thanks for your reply
Unfortunately I cannot upload the file, due to data sensitivity

(But basicly you could just create a fresh excel file with one column, each row containing either 1, 2, 3 or 4)
If a user filters the column I want him/her to be forced to select 1, 2 & 4 (in other words, they should only be able to deselect 3)