cut/copy and paste forumla problem help

[zen_zen]

i am currently using the correlation formula to test on a large set of
data:

e.g.

CORREL(IGR!C233:C262,IIA!C233:C262)

IGR and IIA - they are a pair of data i place in 2 different
worksheets, each has set of data, and I need to pull the data of C233
and C262 in IGR and IIA worksheet


and I have many pairs in different worksheets

E.G. RMR and RHR

so I copy the forumla above and hope can only manually adjust the
symbol from IGR and IIA to RMR and RHR

when I copy it shift the number down

=CORREL(IGR!C242:[/B]C271,IIA!C242:C271)



from C233 to C242 and C 262 to C271 and I would have to manually adjust
it back to C233 and C262


Since I have such a long list of data I need to do, I cannot manually
adjust the number every single times

can anyone help or know a function so that I do not need to manually
adjust it?

so every time when I copy and paste, it will show me

CORREL(IGR!C233:C262,IIA!C233:C262)

again instead of shifting the number down


many thanks

 

[Gord Dibben]

Not completely sure what you're asking for but..............

Add some $ signs to make the cell references absolute.

=CORREL(IGR!$C$233:$C$262,IIA!$C$233:$C$262)

Select the cell and F2 to edit.

Highlight the cell refs in the formula bar and hit F4 key to cycle through your
options.


Gord Dibben MS Excel MVP