I have a column of wattages and a row of impedances (ohms). I want to
calculate the volts from this table of information without having to type in
each cell's formula. I tried copy and paste, but the equation changes part of
itself to the column/row before it and not the row/column I want it to use.

=SQRT(A2*B1) I want the A2 to stay the same in that row as I go across the
columns but the B increment. Ie. C2, D2, E2, etc.

Like wise when I increment down the page, I want the B1 to stay the same but
have the B2 increment. Ie, B3, B4, B5, etc.

This expands to I34.

Solution?
--
I reject your reality and substitute my own.

Promote hydrogen - one of the best "clean" fuels there are!