Set cell action in Microsoft 365 Excel

Use the Set cell action to set a value in an active or a specific cell of an Excel spreadsheet or a CSV file. You can also use this action to set a formula.

Settings

Enter the name of the session used to open the workbook with the Open action.
Select the Active cell or Specific cell option to specify the cell in which to set the value. If you have selected the Specific cell option, specify the address of the cell in the field.
Note: You can enter a cell range in the Specific cell field to set a particular value in all the cells of the range. For example, to set a value of 5 on all cells in the second row and from the first through third column, enter A2:C2.
Enter the value to set in the Cell value field.

Automation 360

Set cell action in Microsoft 365 Excel