How to update copied cells to relative and absolute references

Jackson_Barnett.

Two methods.

1. Use $D$11, $E$11 etc to lock them in place (F4 is the quickest shortcut for that)

2. Name the cells in the wee box to the left of the formula bar. When you write the formula just reference the name you have given it eg A1/rng_Denominator

also if you are need to do a block at a time, you could run a find and replace (including formulas) to look for d11 and replace with $D$11 etc