I'm doing some stuff on excel but can't remember how to copy a formula sequence properly and it's doing my nut in. For example in one cell i have a simple formula i.e. =d1*c22 and i want the cell below to read =d1*c23 and so on etc. But when i try to fill the formula down it increases both sides each time so instead of it saying d1*c23, d1*c24 etc it says d2*c23 d3*c24.

I'm sure it's something very simple that's i've forgotten but it's really annoying me as i'm having to change each cell formula manually...


HELP