thinking about it do u simply use $ to anchor that part of the formula i.e. $d$1*c23 etc.

cheers