to make cell absolute

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

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

"Valma" wrote:

> 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

Select the cell in the formula bar and press F4 a few times until the dollar
sign are gone


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Valma" <Valma@discussions.microsoft.com> wrote in message
news:A5D1FA02-91D5-4CAD-9F5E-5B6EF614A5BF@microsoft.com...
>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