Enter the formula in the cell in the first row of the column (assuming that the cell is E2):

= Inventory-Issue Quantity Press Enter.

Detailed formula input method:

Click the mouse to generate inventory cells and enter an equal sign (=), then click the inventory cells and enter a minus sign (-), and then click the outbound cells and press Enter to automatically generate inventory data.

Before proceeding to the next step, there are three ways to automatically generate inventory data for each row of the whole column:

Method 1. Click the inventory (E2) cell, click the format brush and then click this column, so that the whole column is the same formula, that is, the inventory data is automatically generated.

Method 2 Click the hypothetical E2 cell and drag it down with the drag handle. The inventory data in this column will change with the change of outbound data, that is, the inventory data will be automatically generated.

Method 3 Copy the E2 cell and paste it into other cells in the inventory column.