One more to try. Assuming you do want all the rows to have the formula.
Click on the cell with the formula, put cursor over the bottom right corner
to display the fill handle (crosshair), double click left mouse button. this
should fill all the rows in the column with the fomula.

HTH

Mark

"iculookn2" wrote:


thanks for all your help! the keyboard shortcut rocks dave o.


--
iculookn2
------------------------------------------------------------------------
iculookn2's Profile: http://www.excelforum.com/member.php...o&userid=33783
View this thread: http://www.excelforum.com/showthread...hreadid=535523