The easiest solution would be to first select all by checking the box next to “(Select All)” and then removing checks from boxes representing the items you wish to ignore in your selection.
Continue readingTag Archives: items
How to filter a list of data for multiple items? | Excel 2007
First off you need to apply filter to your column. To do that select the row, cell or cells you wish for the filter to appear and go to Home tab under Editing section. Click on “Sort & Filter” and choose “Filter” from the menu. Now click on the appearing small arrow inside the cell and uncheck “(Select All)” from the selection menu and check the boxes representing the items you wish to appear on your selection.
Continue reading