Hi Sumesh,

Am Wed, 4 Apr 2012 16:46:13 +0000 schrieb sumesh56:

i have a formula on B4 cell. i want to copy this formula to the 2024th
row. holding the shift key and drag is a tiresome job.how can we do this
with a few stroke? thanks

you also can select the range B4:B2024 and then press CTRL+D


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2