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

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

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

thanks for the suggestion. i tried your suggestion in the following and failed to get the result. make me correct plz.

in A1 i put 1
in A2 =A1+1 pressed enter
then i copied cell A2 then p f5 entered A50
the p control shift pageup and p control v
i got 1 instead of 50.
ok dear , i tried with <up arrow and succeed. thanks for the suggestion, have a nice day.