B
braabe01
I have a column to which I want to apply an Auto Filter. The problem is
some of the cells in that column contain multiple values (for example
one cell contains "Screw & Housing"). When I select "Screw" from the
filter menu, it will only show the cells for which the value = "screw".
Is there a way for me to change the Auto Filter menu show that all the
cells that contain "screw" are shown.
I know it's possible to do this by selecting "Custom...", but I want
this to be directly available in the Auto Filter menu so that the
spreadsheet is user friendly.
Thank you,
Ed
some of the cells in that column contain multiple values (for example
one cell contains "Screw & Housing"). When I select "Screw" from the
filter menu, it will only show the cells for which the value = "screw".
Is there a way for me to change the Auto Filter menu show that all the
cells that contain "screw" are shown.
I know it's possible to do this by selecting "Custom...", but I want
this to be directly available in the Auto Filter menu so that the
spreadsheet is user friendly.
Thank you,
Ed