How to apply the below formula to the entire column

[bhanu.priya2 (Bhanu Priya)]

Hi Team,

Kindly find the below screenshot FYR

How do i apply the above formula to the entire column

[fernando_zuluaga]

hi,

kindly check this post

How to drag a formula in the entire column in excel

Hello, The shortcut to “Filldown” is Ctrl+D, so if you can select the range you want the formula to drag down to, then just use TypeInto. For example, Write Cell "formula" Select Range TypeInto "[d(ctrl)]d[u(ctrl)]" ‘d’ for down and ‘u’ for up to simulate the hotkey. (You might be able to use Send Hotkey too. Selecting the range will require that you know the number of rows in your table. You can use dtVar.Rows.Count to find that number, then use it inside the Range field, like "A2:A"+(d…

Regards

[bhanu.priya2 (Bhanu Priya)]

Hi Thanks for your reply but type into is not giving proper solution please find the below screenshot FYR, it is just copying the same to entire Colum

[Rahul_Unnikrishnan]

Hello @bhanu.priya2 ,

You can use Fill Range activity to achieve the same. Check the below doc.

Fill Range

[jack.chan]

download this custom activity and use drag formulas activity

Excel Activities for Processing and Filtering - RPA Component | UiPath...