Setting formula for a range of cells without Write cell activity

I have an excel with more than 1 lakh records, I cannot use write cell activity to set a formula for all cells because it is time consuming. Please suggest a way to set the formula for all rows in a particular column

Hi @Mahalakshmi

Use write cell activity for the one cell and followed by use auto fill activity.