Select Multiple Items (but hide others)

miltonq

New Member
Joined
Sep 2, 2009
Messages
3
Prior to Excel 2007, when you did a "Select Multiple Items" on a drop down list (Report Filter) and chose only the items you wanted seen in the list, users would see "(Multiple Items)" in place of "All". When the clicked on the drop down list, the items they would see would then be ONLY the items that were chosen to be seen. Now, in Excel 2007, the same thing happens, but when users click on the drop down list, they see a check box next to all the items, and are not able to use the field any more for filtering. For example:
Report filter has 5 values. I chose "Select Multiple Items" and I say only show items 1 through 3. When users now go to use that drop down list, they can not simply click on "3" to eliminate 1 and 2, because all that will do is uncheck the check box.
I am looking for the multiple items to basically work more like pre-2007 version in this case.
Any ideas?
Thanks
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Forum statistics

Threads
1,213,536
Messages
6,114,213
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top