Excel Copy Cell Function without changing cell reference?

Normally when we copy/paste excel function, on paste the cell reference is adjusted for the

context of where we are pasting to.

For example:

Copy : from K3: =RANK(J3,J3:J25)

To: to K4: =RANK(J4,J4:J26)

 

Well I want my rank to go over the ENTIRE range from J3:J25, not from a relative range of

J(n) :J25, so how do we do this? Using fixed cell references:

Change our rank to: