When your worksheet is small it is easy to select the items you need for editing or updating. How can you quickly select a group of items if you have 70 line items on your worksheet?
Example: select panels in the worksheet
-
Make sure that you have at least one panel in your worksheet.
-
Click
on the Standard toolbar.
-
Check Advanced.
-
Check Part Description.
Note: If there is an item selected in the worksheet, the Search Selected Items will be checked by default. Make sure to clear this and any other check boxes from previous searches. -
In the Operator column, change equals to contains by selecting it from the drop down.
-
In the Value column type Panel.
-
If there is anything else that all panels have in common select another search criteria.
For instance, if you want to select all panels with product numbers containing ABC…, check Part Number, change the Operator to contains and type ABC under Value. -
Click Select All.
Note: You can also do the same thing using Select by Criteria.