Hi All,

I want copy formula to many cells..

my formula looks something like this..


=SUM('C:\[Test.xlsx]Sheet1'!A1)
if i copy the above formula to cell below it, then it will take it as shown below

=SUM('C:\[Test.xlsx]Sheet1'!A2)
Similarly for all below cell if i keep on copying it ll take A3,A4,A5 etc..

But my requirement is, it should take B1,C1,D1 etc after A1..

is it possible or should i manually add formula to each and every cell?

Thank you.