Hi,

I have 100+ columns of data in an excel, for each column i need to apply a formula and apply it to the entire column and i need to do this to all columns, i can do autofill range one column at a time, but it is taking time to complete the process, is there any other way to apply the formula of the first row of every column to the respective entire column.

TIA

Santhosh