Consolidate combines identical line items into one line item and updates the quantity.
-
Click
on the Worksheet toolbar.
-
In the Consolidate dialog, select or clear the criteria will be used for the consolidation. For example, if you have different tags or discounts in the file clear those columns. The resulting value in the column will be the first value encountered in the worksheet.
-
Click Consolidate.
Note: Any items that are optioned or discounted differently will not consolidate unless the option or discount boxes are cleared.
Click Edit Defaults to change the default consolidate criteria. This is the same as clicking Default Consolidate Criteria in Tools, Preferences, Common.
Click Set Defaults to reapply the default criteria on the dialog box.
Related articles