You can change the value of multiple cells in a BOM in one go, but they must be in the same column.
-
Click
. 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.