Fastest way to write an excel formula into an entire column

Maybe of those approaches could help us to fulfill the entire column with the same formula, just replacing the row number from it.

In this case, I would just write the formula at the first cell with Write Value activity and then apply one of those approaches following the link examples to replace the remaining rows:

  1. Using Send Hotkey activity to simulate the shortcuts that would help in this case.
  2. Using Mouse Click event (Double Clicking, more prone to errors)

For example:

Nevertheless, I’m still analyzing what would be the fastest way to set formulas properly to the whole column.