To Change the Value of Multiple Cells in a BOM
You can change the value of multiple cells in a BOM in one go, but they must be in the same column.
Click
Annotate tab
BOM panel
BOM
.
Find
Press ENTER.
In the BOM List panel, right-click the BOM to edit and select Set current. The
icon indicates the current BOM.
Click the first cell and then SHIFT-click the last cell of the range.
Note:
You cannot select non-contiguous rows.
All cells must be from the same column.
In the toolbar, click
. The Set Value dialog box is displayed.
If the cells contain text only, enter the new value for the cells in the Value box.
To set the same value for all the cells in the selected range (if the cells contain a numeric value):
In the Start value box, enter the value to set for all the cells.
In the Step box, enter 0 (zero).
To change the cell values by specifying a starting number and an increment value (if the cells contain a numeric value):
In the Start value box, enter the number of the first cell in the range.
In the Step box, enter the increment value.
To change the cell value by adding a fixed value to the cells in the range (if the cells contain a numeric value):
Select the Add option.
In the Value box, enter the fixed value by which to increase the existing values.
Click OK until all dialog boxes close.
Related Concepts
About Editing BOMs
Related Tasks
To Sort a BOM
To Change the Item Number of a Single BOM Item
To Change the Item Number of Multiple BOM Items
To Add a User-Defined BOM Item
To Delete a User-Defined BOM Item
To Exclude a BOM Item From Parts Lists
To Enter a Formula to a BOM Cell
To Set an Instance of a Component as a Reference Component
To Merge BOM Rows
To Split a BOM Row
To Add Parts to a BOM
To Delete a BOM
To Rename a BOM
Related Reference
Commands for Working with BOMs Balloons and Parts Lists