Hi,

Is there a way to execute a formula on all rows of a column in excel?

Regards,

Shawn

Hi,

Is there a way to execute a formula on all rows of a column in excel?

Regards,

Shawn

hello @shawnmurray

use **write cell** or **write rang** Activity **inside Excel scope** to write your formula into excel

REgards

Ajay

@shawnmurray

**Source Range** â€”> location of excel cell having formula. (e.g. â€”> **â€śA1â€ť**)

**Fill Range** â€”> The range you want to Autofill, including the cell having formula. (e.g. â€”> **â€śA1:A9â€ť**) This field supports only strings and String variables.

take a look here, Auto Fill Range.zip (26.6 KB)

1 Like

@samir

Okay all that makes sense! Thank you

Where do i input the formula that i want to use?

Regards,

Shawn

Formula should be inserted in a excel cell, and that cell location youâ€™ve to put in **Source Range**

Letâ€™s take a example

here, A1 cell in excel has a **formula**, A2 to A9 cells are blank and you want A2 to A9 cells should follow same formula as A1, In this case you should pass that range including cell having formula, so here its **â€śA1:A9â€ť** getting?

for your understanding Iâ€™d attached sample workflow in my previous post

Go through and youâ€™ll get the idea.

1 Like

@samir

Okay so this is something I do manually in Excel Application before â€śAuto Fill Rangeâ€ť Activity?

Regards,

Shawn

hey @shawnmurray

but you can put the formula by using **Write Cell** too (in quotes), as shown in below shot.

and after the **write cell** activity you simply use **Auto Fill Range**

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.