Coping rank for whole dataset in excel

Hi
i want to work out the ranks for my whole data set, if i type in the formula for the first line then drag it for the rest instead of working out that rank for that entry in the whole dataset it moves the begining of the data set down with the cell ref.


For example, i type =rank(A1;A1:A166,0)


then when i copy it to the other cells instead of getting: =rank(A2;A1:A166,0) etc

i get =rank(A2;A2,A167,0)


how do i get it to work out the of each entry over the dataset without it changing the dataset each time too?

thanks