"marpat" wrote:

How do I change a range of cells from absolute to relative ie. $h$100*f200
to h100*$f$200, $h$101*f201 to h101*$f$201 and so on....

Use Edit Replace. It works in formulas e.g. Find $H$ and replace with H