how to copy a formula to other cells-any shortcut

[sumesh56]

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

 

[Spencer101]

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

Put your formula in the first cell, B4 in this instance, and copy i
(Ctrl+C) then press F5 and in the box that appears type the cell yo
want to go to, B2024 in this instance and press enter or click OK. The
press Ctrl+Shift+Up then paste (Ctrl+V).

Sounds like a long way round but once you've done it a few times it'
second nature and very quick. Far quicker than playing "Excel YoYo
where you keep dragging up and down up and down until giving up an
starting again :

 

[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 can double-click on the drag point. Then the formula will be copied
as far as column A is filled.


Regards
Claus Busch

 

[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

 

[sumesh56]

Hi Sumesh

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


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


Regard
Claus Busc

thanks for the suggestion. i have checked like thi
entered the formula in a1 cell. clicked on it. the went to a20 pressin
the shiftkey. then i pressed control d and i got the result. but if
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) an
enter a3030. pressing the shift key press enter. now the range i
selected. now press control d as suggested by you the formula in a1 i
copied to a3030. done. thanks. is this the method to be followed? am
right

 

[Gord Dibben]

Easiest method for me is to enter the formula in A1 then simply type
A1:A3030 in the NameBox and hit ENTER key to select the range.

Then hit Ctrl + d


Gord