I have a column e.g:

=F5/F4
=F6/F4
=F7/F4
=F8/F4

That I would like to drag and drop to the bottom of the column to
repeat as above instead of:

=F5/F4
=F6/F5
=F7/F6
=F8/F7

Is this possible?

Many thanks


--
Carlie
------------------------------------------------------------------------
Carlie's Profile: http://www.excelforum.com/member.php...o&userid=33377
View this thread: http://www.excelforum.com/showthread...hreadid=534206

Hi Carlie

the formula should be:

=F5/F$4

Regards,
Ivan

Many thanks Ivan


--
Carlie
------------------------------------------------------------------------
Carlie's Profile: http://www.excelforum.com/member.php...o&userid=33377
View this thread: http://www.excelforum.com/showthread...hreadid=534206