Would it be possible to select a value permanently and hide it from the quick filters option?
Assuming the data as 'A,B,C,D, Null' , i'd like the quick filter to show 'A,B,C' while 'Null' is permanently selected and not available to users to change.
Any inputs in this matter would be much appreciated.
Message was edited by: Varun Raj
Attached is a sample workbook.
The conditions I need to get implemented in this are
-> Display 'Null' in the sheet, while not displaying 'Null' in the quick filters. ( permanently select and hide a filter value)
-> Allow users to multi select among the other names (A,B,C,D)
Hi Sandip,
Not exactly.
This is what I would need the data to look like.
And the quick filter should be like
In short, a particular value to be displayed in the worksheet ( NULL in this case, as highlighted in first screenshot ), but not part of the quick filter ( has just the remaining A,B,C,D ).
