to make cell absolute

V

Valma

I have made a cell absolute G3/$H$2 , I cannot drag the formula down the
column it it just coping to the next line. please help
 
J

Jim B

You should be able to copy it, do you plan to divide G3..G100 by H2?

highlight the cell with the formula in it; right click click copy, then
highlight the range you wish to copy the formula to then paste.

Jim
 
Top