Fastest way to write an excel formula into an entire column

Help
3

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:

image.png720×245 13.6 KB

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

5 Likes