Batch Edit


1. For the cells with a dropdown: multiple possible values columns, meaning usually the ones that contain text in the cells and not numbers.

1.1 Right click on any cell in any columns that are not in the columns "Last Modified" or in "Debug".

1.2 To modify one cell, you only click right on one cell. For example, in the picture below, you can see I clicked right on a cell in Surface Finish. To modify one cell, you only click right on one cell. A menu bar will appear with four options.

1.3 To modify multiple cells

    1.3.1 Select Rows:

  • Press the Shift key on your keyboard.
  • Simultaneously, click on the first row you want to edit.
  • Then, click on the last row in the range you wish to modify.

    1.3.2 Batch Edit:

  • As shown in the picture below, you’ll notice that multiple rows are highlighted in blue. This indicates that they are all selected for batch editing.

    1.3.3 Context Menu:

  • To apply the changes, right-click in the column where you want to edit the values between the highlighted blue rows. A context menu button will appear.

    1.3.4 You can also select multiple rows by pressing the CTRL key on your keyboard and simultaneously clicking different dispersed rows, as shown below. Then, right-click on one of the highlighted cells.

1.4 If you’ve chosen to modify only one row, select the option “Edit Row.” If you’ve selected multiple rows, choose the option “Edit Selected Rows.”

1.5  After making your selection, a pop-up window will appear. In this window, you’ll find a dropdown menu with the possible values you can choose from to modify the current value.

1.6 After selecting your desired value, click the “Apply” button. A pop-up Confirmation window will appear, displaying the number of rows you are modifying. You’ll have two options:

  • “Confirm”: Proceed with the modifications.
  • “Cancel”: Return to the pop-up editing window without applying the changes.

a) modifying one row

b) modifying multiple rows

1.7  Once you’ve clicked the “Confirm” button, the changes will be applied to the selected cells. Here’s a visual representation of how it looks: