how to copy a formula to other cells-any shortcut

sumesh56;1600449 Wrote:

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 :


Spencer101