Quote:
Originally Posted by Claus Busch
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
|
thanks for the suggestion. i have checked like this
entered the formula in a1 cell. clicked on it. the went to a20 pressing the shiftkey. then i pressed control d and i got the result. but if i have to select a 3030 what is method to select the range?
how select the range?
ok u have made it. you enter a formula in a1. then press f5(goto) and enter a3030. pressing the shift key press enter. now the range is selected. now press control d as suggested by you the formula in a1 is copied to a3030. done. thanks. is this the method to be followed? am i right?